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

111 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
delusion93743(None) 
delusions1037051delusions
elusion72310951_elusion
allusion846572allusion
decision1148522decision
decurion1146622decurion
delation92318082delation
deletion92011972deletion
delusional1153302delusional
delusive1245842delusive
derision939072derision
detrusion1044382detrusion
dilution9239142dilution
diluvion12215412diluvion
elision72311102_elision
elusions82610082_elusions
elution72913822_elution
illusion846572illusion
prelusion1156602prelusion
reclusion1146502reclusion
seclusion1144942seclusion
ablution1047223ablution
affusion1443923affusion
allusions946013allusions
alluvion1144733alluvion
avulsion1153863avulsion
cession939813ce_ssion
collusion1146413collusion
dealation10313003dealation
decisions1248383decisions
declension1343513declension
decurions1246023decurions
deduction1377083deduction
deflation13310653deflation
deflexion2042823deflexion
defusing13227933defusing
delations102616593delations
deletions102610933deletions
delousing1136303delousing
deluding1137683deluding
deluging1137123deluging
delusionary1552503delusionary
delusory1273003delusory
deluster936903deluster
demission1246033demission
demotion1169073demotion
depletion1256663depletion
derisions1038843derisions
design8408933de__sign
detrusions1144213detrusions
devolution1486283devolution
devotion1256763devotion
diffusion1643973diffusion
dilation92215463dilation
dilutions10248583dilutions
diluvian12194663diluvian
diluvions13224443diluvions
disunion956113disunion
division1266683division
divulsion1343553divulsion
durion7510963d__urion
eclosion1046893eclosion
effusion1444603effusion
elation73620453_elation
elisions82210423_elisions
elusive1057003_elusive
elutions82513053_elutions
elysian1065083_elysian
emulsion1045923_emulsion
erasion7311963_erasion
erosion7311113_erosion
evasion1036753_evasion
evulsion1155063_evulsion
exclusion1845223exclusion
fluxion1735043_fluxion
fusion939773__fusion
gelation93014433gelation
hellion10311133hel_lion
illusions946213illusions
inclusion11166213inclusion
infusion1146523infusion
kelson1038153kel_s_on
lesion64715063__lesion
nelson638423nel_s_on
neuston736083ne_uston
occlusion1343973occlusion
pension9412203pe_nsion
perfusion14105883perfusion
pleuston1044193pleuston
plosion939113_plosion
preclusion1445213preclusion
prelusions1256373prelusions
prolusion1146363prolusion
pulsion938393pul_sion
recision10310273recision
reclusions1246243reclusions
recursion1146153recursion
relation82619773relation
religion996743religion
repulsion1145193repulsion
reunion737673re_union
revision1138713revision
revulsion1244353revulsion
seclusions1244633seclusions
session739763se_ssion
solution889593solution
tellurion9134013tellurion
telson6310293tel_s_on
tension7311803te_nsion
version10310923ve_rsion
volution1198603volution

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621116.42322756.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.90925863.5
 
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.