不幸的是，不支持近似字符串匹配.您可以获得的最接近的结果是使用正则表达式.***的选择是将数据标准化后再使用BigQuery，即将"Rhodes USA"和"Rhodes，USA."转换为相同的字符串.但是，我将为此功能添加功能请求错误.

Unfortunately, approximate string matching is not supported. The closest you can get is by using regular expressions. Your best bet may be to normalize the data before it gets to BigQuery -- i.e transform "Rhodes USA" and "Rhodes, USA. " into the same string. I'll add a feature request bug for this support, however.