Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “expatriates” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
expatriates205354(None) 
expatiates1944891expat_iates
expatriate1954041expatriate_
expatriated2153081expatriated
expatiate1845422expat_iate_
expatiated2044202expat_iated
expatriatism2362822expatriatism
patriates11311362__patriates
repatriates1385322repatriates
elutriates1045003e_lutriates
excoriates1946323ex_coriates
expatriating2253063expatriating
expatriation2154333expatriation
expatriations2253763expatriations
expatriatisms2462283expatriatisms
expiates17810213exp___iates
expropriates23103403expropriates
expurgates2043523exp_urgates
extricates1998243ex__tricates
patriate10311933__patriate_
patriated1238533__patriated
repatriate12115953repatriate_
repatriated14114893repatriated
apatites10311294_apat_i_tes
aspartates1244674aspa_rtates
covariates1545784cova_riates
elaterites1048284e_lateri_tes
elutriate945304e_lutriate_
elutriated1144554e_lutriated
emaciates1347884e_ma_ciates
empathies16115404empathi__es
empathises17104064empathi_ses
empathizes2673444empathi_zes
ephorates1459164e_phor_ates
eradiates102010784e_ra_diates
espadrilles1451554espadrilles
eupatridae1351564eupatridae_
eupatrids1243084eupatri__ds
evaporates1545464evapor_ates
evaporites1544654evapori_tes
exacerbates22113064exacerbates
exarchates2243964ex_archates
excavates2144684exca__vates
excoriate1846884ex_coriate_
excoriated2045324ex_coriated
excruciates2252634excruciates
execrates1839564ex_ecr_ates
exenterates1885374exenterates
exfoliates2063704ex_foliates
exonerates17107344exoner_ates
expatiating2144364expat_iating
expatiation2046834expat_iation
expatiations2146134expat_iations
expectorates2353004expectorates
expedites1946164exp_edi_tes
expertises1947104experti_ses
expertizes28106014experti_zes
expiate16910594exp___iate_
expiated18168524exp___iated
expiries1747754exp_iri__es
explicates2196664exp_licates
expostulates2152354expostulates
expropriate2253784expropriate_
expropriated2452994expropriated
expurgate1943824exp_urgate_
expurgated2143064exp_urgated
extirpates1943684ex_tirpates
extricate1869074ex__tricate_
extricated2067084ex__tricated
extubates1844844ex__tubates
exuberates1945284exuber_ates
exuviates1945374ex__uviates
impetrates1445454impetr_ates
palliates11311034__palliates
parietes10714544__pa_rietes
patinates113814694__patinates
patriciates1545324__patriciates
patriots1038054__patriot_s
perpetrates1566204perpetr_ates
satiates8314634__sat_iates
separates11310744sepa_r_ates
striates83417084___striates
variates111214984__va_riates
vicariates1565534vica_riates

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.406440125.6
2DLD Change Limit148819848.33017865.4
3Display Results84840.0461826.1
 (SQL Overall)178691848.78220347.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.