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 “emulation” 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.

157 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
emulation1131239(None) 
emulations12310941emulations
adulation10311012adulation
ambulation1447872ambulation
cumulation1448172cumulation
education12310202education
elation73620452e__lation
emanation11910782emanation
emulating1239872emulating
emulative1447452emulative
emulator1048742emulat_or
emulsion1045922emul_sion
epilation11312962epilation
equation17310482equ_ation
exudation1787692exudation
exultation1747532exultation
mutation101412882_mutation
ovulation1238982ovulation
peculation14311992peculation
regulation11312052regulation
simulation1269582simulation
ululation938092ululation
ablation10312433_ablation
acylation1448653acylation
adulations11310123adulations
alation72920553__alation
ambulations1547113ambulations
amputation1447343amputation
angulation1149553angulation
annulation1068953annulation
caudation1269993caudation
causation1199523causation
chelation1439973chelation
collation11313993collation
copulation141111953copulation
crenulation1347573crenulation
cumulations1547433cumulations
dealation10313003dealation
deflation13310653deflation
delation92318083_delation
demodulation1644693demodulation
demolition1376983demolition
denudation1247303denudation
depilation13312033depilation
deputation1339393deputation
desolation11311403desolation
dilation92215463_dilation
duration9312693_duration
ebullition1242593ebullition
educations1339233educations
eduction1169053edu_ction
ejaculation2096133ejaculation
elations83719123e__lations
elevation1239233elevation
elution72913823e__lution
eluviation1376613eluviation
emaciation1449283emaciation
emanations1289593emanations
emasculation1655233emasculation
emblazon2143023embla_zon
emendation1346553emendation
emigration13228213emigration
emotion9711303em__otion
emulate9314123emulat__e
emulated11310793emulat_ed
emulates10312573emulat_es
emulators1148183emulators
emulsions1145343emul_sions
enation73419233e__nation
enucleation1344513enucleation
epilations12311713epilations
equations1839493equ_ations
equitation1948343equitation
eructation1248333eructation
erudition1046173erudition
eruption1047043eru_ption
escalation1248873escalation
etiolation1048533etiolation
eulachon1353003e_ulachon
evaluation1358183evaluation
evocation142010293evocation
evolution12117093evolution
evulsion1155063evul_sion
exaltation1748493exaltation
exculpation2244873exculpation
exhalation2046653exhalation
exhumation2244693exhumation
expiation18710423expiation
exudations18107073exudations
exultations1846523exultations
exuviation20116343exuviation
fellation1238843fellation
formulation1646363formulation
gelation93014433_gelation
gemination131410663gemination
gemmation1445963gem_mation
halation11313853_halation
illation8311943_illation
imitation11510853imitation
immolation1446103immolation
impletion1345403impletion
imputation1447123imputation
inflation12311093inflation
insulation10311663insulation
isolation9311643isolation
lallation939493lallation
laudation1088133laudation
lobulation1247233lobulation
lunation8311923_lunation
luxation1538233_luxation
maculation14510983maculation
malathion1444513_malathion
mediation12312293mediation
mentation11313983mentation
modulation13147933modulation
morulation12148903morulation
mulatto944733_mulatto_
mulattos1044083_mulattos
mullion91911173_mul_lion
multiton1087343_mul_titon
munition1038763_munition
mutations111211453_mutations
mutilation1249753_mutilation
neurulation1145343neurulation
nodulation11127993nodulation
nutation81513103_nutation
oblation1039863_oblation
osculation1249673osculation
ovulations1337973ovulations
peculations15310283peculations
permutation1547473permutation
population14810023population
pulsation1137143_pulsation
pupation1269503_pupation
reflation12412333reflation
refutation1349913refutation
regulations12310713regulations
relation82619773_relation
reputation12411883reputation
revelation13410923revelation
scalation11311073scalation
simulations1368393simulations
solation8916153_solation
speculation1547543speculation
stimulation1377223stimulation
sublation11311013sublation
sudation9310803_sudation
sulcation11710733_sulcation
sulfation1288783_sulfation
summation1347803summation
tabulation1247813tabulation
temptation1446383temptation
ululations1037143ululations
undulation1147103undulation
vallation1239753vallation
valuation1249973valuation
violation1238443violation

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411576.65622331.9
3Display Results1571570.0602616.7
 (SQL Overall)1786911577.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.