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

173 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
elusion7231095(None) 
delusion937431delusion
elision72311101elision
elusions82610081elusions
elution72913821elution
allusion846572allusion
delusions1037052delusions
eclosion1046892eclosion
effusion1444602effusion
elation73620452elation
elisions82210422elisions
elusive1057002elusive
elutions82513052elutions
elysian1065082elysian
emulsion1045922emulsion
erasion7311962erasion
erosion7311102erosion
evasion1036752evasion
evulsion1155062evulsion
exclusion1845222exclusion
fluxion1735042fluxion
fusion939772_fusion
illusion846572illusion
lesion64715062_lesion
plosion939112plosion
prelusion1156602prelusion
pulsion938392pulsion
reclusion1146502reclusion
seclusion1144942seclusion
ablution1047223ablution
affusion1443923affusion
alation72920553alation
allusions946003allusions
alluvion1144733alluvion
alumin8513543alumi_n
avulsion1153863avulsion
basion84315853_basion
blouson974893blous_on
bullion91911033bullion
bunion83111313_bunion
caution93013513caution
cession939813cession
clarion9311663clarion
classon937693classon
collusion1146413collusion
cousin8517153cousi_n
cullion91910233cullion
cushion1236403_cushion
decision1148523decision
decurion1146623decurion
delation92318083delation
deletion92011973deletion
delusional1153303delusional
delusive1245843delusive
derision939063derision
detrusion1044373detrusion
dilution9239143dilution
diluvion12215413diluvion
durion7510963_durion
eclosions1146203eclosions
edition8310853edition
eduction1169053eduction
effluxion2251853effluxion
effusions1544373effusions
eftsoon1043253eftsoon
egestion946863egestion
elain55324703el_ai_n
elastin72611843elastin
elations83719123elations
election102015353election
elevon977953el_evon
elfin84312463el_fi_n
elocution1145673elocution
eloign7456983el_oign
eloin55923203el_oi_n
eluding93412113eluding
elusory1083993elusory
eluting84115293eluting
eluvia936133eluvi_a
eluvial1045853eluvial
eluvium1244973eluvium
elytron1045463elytron
emersion1047733emersion
emission1047673emission
emotion9711303emotion
emulsions1145343emulsions
enation73419233enation
ensign737523e_nsign
envision1145953envision
eosin55220923e_osi_n
epsilon944293e_psilon
equation17310483equation
erasions8310983erasions
erosions8310333erosions
eruption1047033eruption
essoin638193e_ssoin
etesian757853etesian
ethion938813e_thion
evasions1136543evasions
eversion1138713eversion
evolution12117093evolution
evulsions1254573evulsions
excision1746273excision
exclusions1945013exclusions
excursion1844613excursion
explosion18115213explosion
expulsion1843893expulsion
extrusion1645253extrusion
fission1038733fission
flexion1735073flexion
fluxions1844423fluxions
fusions1039153_fusions
gelation93014433gelation
gluon6311223glu__on
glutton844893glutton
grunion835433grunion
hellion10311133hel_lion
illusions946213illusions
inclusion11166213inclusion
infusion1146523infusion
kelson1038153kel_s_on
lection92614863lection
legion75712983_legion
lesions73813863_lesions
lesson64412043_lesson
leucin839113leuci_n
leukon1036143leu_kon
lion46334443_l__ion
logion76013723_logion
lotion65716523_lotion
lupin75215843_lupi_n
lysin84512783_lysi_n
mansion9611543mansion
mission9312743mission
mullion91911173mullion
nasion63914083_nasion
nelson638423nel_s_on
neuston736083neuston
occlusion1343973occlusion
passion9310883passion
pension9412203pension
perfusion14105873perfusion
plasmon11257983plasmon
pleuston1044193pleuston
plosions1038023plosions
pluton838853plu_ton
pluvian1245333pluvian
preclusion1445213preclusion
prelusions1256373prelusions
prolusion1146363prolusion
pulsions1037713pulsions
recision10310273recision
reclusions1246243reclusions
recursion1146153recursion
relation82619773relation
religion996743religion
repulsion1145193repulsion
reunion737673reunion
revision1138713revision
revulsion1244353revulsion
seclusions1244633seclusions
session739743session
solution889593solution
suasion739363suasion
tellurion9133993tellurion
telson6310293tel_s_on
tension7311803tension
torsion7310803torsion
turion6313163_turion
union54519793__union
version10310923version
vision9311313_vision
volution1198603volution

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271736.98319193.3
3Display Results1731730.0632746.0
 (SQL Overall)1786911737.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.