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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
emanations128959(None) 
emanation11910781emanation_
damnations1337082damnations
emaciations1548162emaciations
emanating1239002emanati_ng
emanators1147032emanat_ors
emendations1446052emendations
emulations12310942emulations
enations83316902e__nations
geminations14139262geminations
planations1238722planations
adnations1039753_adnations
agnations10310033_agnations
alations82518893__alations
amanitins1147133amaniti_ns
carnations12311353carnations
cementations1659013cementations
clavations1546183clavations
cognations1339593cognations
conations111318903_conations
connations12312943connations
crenations12511693crenations
damnation1238403damnation_
darnations1138413darnations
dealations11311373dealations
deaminations151010133deaminations
decantations1547943decantations
defamations1745893defamations
demarcations1746123demarcations
detonations1239373detonations
dominations14611043dominations
donations101112353_donations
educations1339233educations
elations83719123e__lations
elevations1338633elevations
eliminations1447613eliminations
elongations1244663elongations
emaciation1449283emaciation_
emanates10311333emanat__es
emanative1447313emanati_ve
emanator1047293emanat_o_r
emancipations1953743emancipations
emarginations1674153emarginations
embarkations2062253embarkations
emendation1346553emendation_
emigrations14187153emigrations
emotions10610283em__otions
emulation11312393emulation_
enation73419233e__nation_
epilations12311713epilations
equations1839493e_quations
escalations1347663escalations
evacuations1646303evacuations
evaginations1645823evaginations
evaluations1457323evaluations
evocations15259873evocations
exactions1838923exa_ctions
exaltations1847293exaltations
examinations2167463examinations
excavations2345083excavations
exhalations2146023exhalations
expiations1959663expiations
explanations2144623explanations
exudations18107073exudations
gemination131410663gemination_
gemmations1545003gem_mations
germinations15137943germinations
gradations1286863gradations
halations12312393_halations
imaginations1546343imaginations
imitations1259963imitations
inanitions1046383inanitions
laminations1339803laminations
lavations1238973_lavations
laxations1637623_laxations
lunations9310723_lunations
malathions1543873_malathions
manakins14209763_manaki_ns
mansions1069793_man_sions
marathons1446423_marathons
marinations13411273_marinations
mediations13310983mediations
mentations12312583mentations
mentions10312893_men_tions
methanations1743973methanations
monitions11310883_monitions
munitions1138173_munitions
mutations111211453_mutations
natations91412493_natations
nations74720563___nations
nominations13410533nominations
nunnations1095903nunnations
ozonations1945143ozonations
phonations1538313phonations
pinnations1236883pinnations
placations1438583placations
planation11310123planation_
plantations1347473plantations
pronations12314033pronations
recantations1448873recantations
relaxations1845643relaxations
reparations13611663reparations
ruinations1039603ruinations
ruminations1349393ruminations
sanctions1138873_sanctions
scalations1239783scalations
separations1369273separations
stagnations1244903stagnations
tarnations1038903tarnations
taxations1636863_taxations
temptations1545413temptations
terminations14149763terminations
trepanations1444573trepanations
urinations10310693urinations
vacations141910553_vacations
venations12311723_venations
vernations13310333vernations
zonations18139313_zonations

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit1406031185.76624384.8
3Display Results1181180.0631873.0
 (SQL Overall)1786911186.24928595.1
 
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.