From Import: 1505 S DIXIE ST

query
RESULTSET	query   ADDRESS ADDRESS2 CITY COMPANYNAME COMPANYTYPE DATECREATED FSL_CHOID HOSTLOCATION INDEPENDENTYN LINKCOUNT PKID RECORDSOURCE SCORE SEGMENTID STATE ZIPCODE addressEditDistance addressEditDistance2 companyNameEditDistance stdAddress stdAddress2 totalEditDistances 1 1505 S. Dixie Street [empty string] Horse Cave Signature HealthCARE of Hart County Rehab & Wellness Center U [empty string] [empty string] [empty string] [empty string] 45 213519 CMS 0 5 KY 42749 0 255 0 1505 S DIXIE ST [empty string] 0
CACHED	false
EXECUTIONTIME	1
SQL	select *, companyNameEditDistance + addressEditDistance as totalEditDistances from qmd_operatorLookup where (( addressEditDistance = 0 or addressEditDistance2 = 0 ) and companyNameEditDistance <= 4 ) or (( addressEditDistance <= 1 or addressEditDistance2 <= 1 ) and companyNameEditDistance <= 2 ) or ( companyNameEditDistance = 0 and addressEditDistance = 255 ) order by companyNameEditDistance, addressEditDistance