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

110 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
delusions103705(None) 
delusion937431delusion_
elusions82610081_elusions
allusions946012allusions
decisions1248382decisions
decurions1246022decurions
delations102616592delations
deletions102610932deletions
delusional1153302delusional
derisions1038842derisions
detrusions1144212detrusions
dilutions10248582dilutions
diluvions13224442diluvions
elisions82210422_elisions
elusion72310952_elusion_
elutions82513052_elutions
illusions946212illusions
prelusions1256372prelusions
reclusions1246242reclusions
seclusions1244632seclusions
ablutions1146603ablutions
affusions1543623affusions
allusion846573allusion_
alluvions1254373alluvions
avulsions1243263avulsions
cessions1039853ce_ssions
collusions1245973collusions
dealations11311373dealations
decision1148523decision_
declensions1443333declensions
decurion1146623decurion_
deductions1467133deductions
deflations1439713deflations
deflexions2142563deflexions
defusing13227933defusi_ng
delation92318083delation_
deletion92011973deletion_
delicious1246713delicious
delirious1045603delirious
delousing1136303delousi_ng
deluding1137683deludi_ng
deluging1137123delugi_ng
delusionary1552503delusionary
delusive1245843delusi_ve
delusory1273003delus_ory
delusters1035983delusters
demissions1345663demissions
demotions1258443demotions
depletions1355743depletions
derision939073derision_
designs9328313de__signs
detrusion1044383detrusion_
devolutions15106263devolutions
devotions1356593devotions
diffusions1743733diffusions
dilations102614453dilations
dilution9239143dilution_
diluvion12215413diluvion_
disunions1055973disunions
divisions1396283divisions
divulsions1443343divulsions
durions839963d__urions
eclosions1146203eclosions
effusions1544373effusions
elations83719123_elations
elision72311103_elision_
elution72913823_elution_
emulsions1145343_emulsions
erasions8310983_erasions
erosions8310343_erosions
evasions1136543_evasions
evulsions1254573_evulsions
exclusions1945013exclusions
fluxions1844423_fluxions
fusions1039153__fusions
gelations102513093gelations
hellions11310023hel_lions
illusion846573illusion_
inclusions1275653inclusions
infusions1246143infusions
kelsons1137323kel_s_ons
lesions73813873__lesions
nelsons738003nel_s_ons
neustons836833ne_ustons
occlusions1443713occlusions
pensions10311693pe_nsions
perfusions1595333perfusions
pleustons1144283pleustons
plosions1038023_plosions
preclusions1544663preclusions
prelusion1156603prelusion_
prolusions1245883prolusions
pulsions1037713pul_sions
recisions1139913recisions
reclusion1146503reclusion_
recursions1245403recursions
relations92418333relations
religions1086603religions
repulsions1244793repulsions
reunions837273re_unions
revisions1238593revisions
revulsions1344263revulsions
seclusion1144943seclusion_
sessions839723se_ssions
solutions988883solutions
tellurions10103803tellurions
telsons739223tel_s_ons
tensions8310223te_nsions
versions11310353ve_rsions
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 Filter1786911486410.420425454.8
2DLD Change Limit1486411107.75019179.5
3Display Results1101100.1101000.0
 (SQL Overall)1786911108.28021581.0
 
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.