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

170 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
elusions8261008(None) 
delusions1037051delusions
elisions82210421elisions
elusion72310951elusion_
elutions82513051elutions
allusions946012allusions
delusion937432delusion_
eclosions1146202eclosions
effusions1544382effusions
elations83719122elations
elision72311102elision_
elution72913822elution_
emulsions1145342emulsions
erasions8310982erasions
erosions8310342erosions
evasions1136542evasions
evulsions1254572evulsions
exclusions1945012exclusions
fluxions1844422fluxions
fusions1039152_fusions
illusions946212illusions
lesions73813872_lesions
plosions1038022plosions
prelusions1256372prelusions
pulsions1037712pulsions
reclusions1246242reclusions
seclusions1244632seclusions
ablutions1146603ablutions
affusions1543633affusions
alations82518893alations
allusion846573allusion_
alluvions1254373alluvions
alumins9512983alumi_ns
avulsions1243263avulsions
basions94213953_basions
blousons1054403blous_ons
bullions101710043bullions
bunions92210473_bunions
cautions103313183cautions
cessions1039853cessions
clarions10310493clarions
classons1037703classons
collusions1245973collusions
cousins9516003cousi_ns
cullions10219223cullions
cushions1335693_cushions
decisions1248383decisions
decurions1246023decurions
delations102616593delations
deletions102610933deletions
delusional1153303delusional
derisions1038843derisions
detrusions1144213detrusions
dilutions10248583dilutions
diluvions13224443diluvions
durions839963_durions
eclosion1046903eclosion_
editions9310403editions
eductions1268773eductions
effluxions2351733effluxions
effusion1444613effusion_
eftsoons1142613eftsoons
egestions1046703egestions
elains64919853el_ai_ns
elastins82111743elastins
elation73620453elation_
elections112414973elections
elevons1067573el_evons
elfins94810943el_fi_ns
elocutions1245963elocutions
eloigns8425353el_oigns
eloins65419383el_oi_ns
eluding93412113eludi_ng
elusive1057003elusi_ve
elusory1083993elus_ory
eluting84115293eluti_ng
eluviums1343863eluviums
elysian1065083elysian_
emersions1147283emersions
emissions1146923emissions
emotions10610283emotions
emulsion1045923emulsion_
enations83316903enations
ensigns836353e_nsigns
envisions1245613envisions
eosins64419163e_osi_ns
epsilons1044223e_psilons
equations1839493equations
erasion7311963erasion_
erosion7311123erosion_
eruptions1146763eruptions
essoins737603e_ssoins
etesians845473etesians
ethions1038483e_thions
evasion1036753evasion_
eversions1238363eversions
evolutions13107043evolutions
evulsion1155063evulsion_
excisions1846383excisions
exclusion1845223exclusion_
excursions1944323excursions
explosions19134663explosions
expulsions1943833expulsions
extrusions1745163extrusions
fissions1138033fissions
flexions1844413flexions
fluxion1735043fluxion_
fusion939773_fusion_
gelations102513093gelations
gluons738503glu__ons
gluttons944273gluttons
grunions945353grunions
hellions11310023hel_lions
illusion846573illusion_
inclusions1275653inclusions
infusions1246153infusions
kelsons1137323kel_s_ons
lections102413843lections
legions84611783_legions
lesion64715063_lesion_
lessons73811023_lessons
leucins938103leuci_ns
leukons1135753leu_kons
lions55923213_l__ions
logions86211293_logions
lotions74614763_lotions
lupins84514463_lupi_ns
luscious1044853_luscious
lysins94610953_lysi_ns
mansions1069793mansions
missions10311903missions
mullions101910353mullions
nasions73112383_nasions
nelsons738003nel_s_ons
neustons836833neustons
occlusions1443713occlusions
passions10310583passions
pensions10311693pensions
perfusions1595333perfusions
plasmons12217663plasmons
pleustons1144283pleustons
plosion939113plosion_
plutons938343plu_tons
pluvious1344443pluvious
preclusions1544663preclusions
prelusion1156603prelusion_
prolusions1245883prolusions
pulsion938393pulsion_
recisions1139913recisions
reclusion1146503reclusion_
recursions1245403recursions
relations92418333relations
religions1086603religions
repulsions1244793repulsions
reunions837273reunions
revisions1238593revisions
revulsions1344263revulsions
seclusion1144943seclusion_
sessions839723sessions
solutions988883solutions
suasions838783suasions
tellurions10103803tellurions
telsons739223tel_s_ons
tensions8310223tensions
torsions839183torsions
turions7311573_turions
unions64216753__unions
versions11310353versions
visions10311023_visions
volutions12108393volutions

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621708.11018022.4
3Display Results1701700.0632698.4
 (SQL Overall)1786911708.59320794.9
 
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.