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 “emaciate” with Change Limit: [1] [2] [3] [4]

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

92 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
emaciate124875(None) 
emaciated1446931emaciated
emaciates1347881emaciates
emanate9312472ema_nate
emancipate1653542emancipate
eradiate91911752eradiate
evacuate13217302evacuate
glaciate1168072glaciate
acuate8315633__acuate
aviate9315203__aviate
baccate131011263_baccate
brachiate1646873brachiate
craniate10312563craniate
cruciate1287313cruciate
dacite91115883_daci_te
demarcate1446613demarcate
deracinate1356563deracinate
ecaudate1145313ecaudate
edacity1336373edaci_ty
educate10310213educ_ate
egalite8311563egali_te
ejaculate18187163ejaculate
elucidate1265413elucidate
eluviate1146953eluviate
emaciating1546813emaciating
emaciation1449283emaciation
emanated1139163ema_nated
emanates10311333ema_nates
emancipated1852873emancipated
emancipates1753233emancipates
emarginate1385453emarginate
emasculate1445553emasculate
emeerate10410103emeerate
emendate1146763emendate
emeritae1046353emeritae
emigrate1149603emigrate
emirate91015833em_irate
emulate9314123em_ulate
enunciate1145743enunciate
eradiated11178813eradiated
eradiates102010783eradiates
eradicate1259183eradicate
eructate1047333eructate
escalate1039323escalate
evacuated15196263evacuated
evacuates14256803evacuates
evaginate1376483evaginate
evaluate11287793evaluate
exanimate1845663exanimate
exarchate2144453exarchate
excavate2045053excavate
excite15310883e_xci_te
execrate1739653execrate
expatiate1845423expatiate
expiate16910593e_xpiate
exuviate1846063exuviate
faciae112913413_facia_e
fasciate1347563fasciate
glaciated1365753glaciated
glaciates1267343glaciates
gladiate1057053gladiate
hematite131612153hemati_te
imamate1138103ima_mate
kamacite1645293kamaci_te
labiate91313573_labiate
lactate9312693_lactate
leachate1347443leachate
macerate122314073_macerate
machete14310883_machete
machinate1647953_machinate
macrame1338713_macrame
maculate122815623_maculate
magnate10512703_magnate
malate84624553_ma_late
maleate94117543_maleate
mammate104411273_mammate
mandate10315573_mandate
marinate103017783_marinate
mediate103415213_mediate
medicate13513243medicate
muriate9313363_muriate
placate11312433plac_ate
radiate83416313_radiate
remediate1247543remediate
reradiate10179033reradiate
retaliate9410633retaliate
saccate111311763_saccate
satiate7315403_satiate
speciate12209583speciate
tractate10411003tractate
vacate11314553_vac_ate
variate101316433_variate

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162927.45319611.2
3Display Results92920.0332787.9
 (SQL Overall)178691927.90622601.9
 
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.