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

118 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
dilution923914(None) 
dilation92215461dilation
dilutions10248581dilutions
diluvion12215421diluvion
ablution1047222ablution
delation92318082delation
deletion92011972deletion
delusion937432delusion
diction102313052di_ction
dilations102614452dilations
diluting10248982diluting
dilutive1255382dilutive
dilutor8256012dilut_or
diluvian12194672diluvian
diluvions13224442diluvions
disunion956112disunion
elution72913822_elution
solution889592solution
volution1198602volution
ablation10312433ablation
ablutions1146603ablutions
adulation10311013adulation
alation72920553_alation
allusion846573allusion
alluvion1144733alluvion
bilection13156803bilection
billion92212173bil_lion
calutron1045553calutron
caution93013523_caution
ciliation111112493ciliation
citation10314363citation
dalton7311273dal_t_on
dealation10313003dealation
decurion1146623decurion
deduction1377083deduction
deflation13310653deflation
delations102616593delations
deletions102610933deletions
delusions1037053delusions
demotion1169073demotion
depilation13312033depilation
depletion1256663depletion
devolution1486283devolution
devotion1256763devotion
diatron839283di_atron
dictation12810563dictation
dictions111812673di_ctions
diffusion1643983diffusion
digestion1146573digestion
dilatation1147393dilatation
dilating102714913dilating
dilative1239523dilative
dilator82712793dilat_or
dilute72911803dilut__e
diluted9248933dilut_ed
diluter8319663dilut_er
diluters9288113diluters
dilutes82911973dilut_es
dilutors9306653dilutors
diluvia11225253diluvi_a
diluvial12224643diluvial
diluvium1443563diluvium
diminution1344813diminution
direction1289783direction
disruption13135733disruption
dissolution12145023dissolution
disunions1055973disunions
diuron738573di_u_ron
division1266683division
divulsion1343553divulsion
donation91513783donation
dotation91412733dotation
duration9312693duration
durion7510963d__urion
edition8310853edi__tion
elation73620453_elation
elusion72310953_elusion
elutions82513053_elutions
epilation11312963epilation
evolution12117093evolution
fiction122010733fi_ction
filiation121110243filiation
fixation1837073fixation
fluxion1735043_fluxion
gelation93014433gelation
glutton844893_glutton
halation11313853halation
himation1339753himation
ideation9310493ideation
illation8311943illation
illusion846573illusion
jillion14188933jil_lion
kiloton1196313kilot_on
libation102411363libation
ligation92313093ligation
liquation1846553liquation
locution10227663locution
lotion65716523__lotion
million91813143mil_lion
misunion1084943misunion
nidation9410583nidation
oblation1039863oblation
pillion92011703pil_lion
pluton838853_plut_on
pollution1146003pollution
relation82619773relation
siltation939213siltation
silurian846293silurian
sinuation9310413sinuation
situation949423situation
solation8916153solation
solutions988883solutions
valuation1249973valuation
violation1238443violation
volition1179173volition
volutin1098103voluti_n
volutions12108393volutions
zillion16188773zil_lion

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621187.22020244.0
3Display Results1181180.0432744.2
 (SQL Overall)1786911187.66923300.4
 
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.