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 “dilutions” 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
dilutions1024858(None) 
dilations102614451dilations
dilution9239141dilution_
diluvions13224441diluvions
ablutions1146602ablutions
delations102616592delations
deletions102610932deletions
delusions1037052delusions
dictions111812672di_ctions
dilation92215462dilation_
diluting10248982diluti_ng
dilutors9306652dilut_ors
diluvion12215422diluvion_
disunions1055972disunions
elutions82513052_elutions
solutions988882solutions
volutions12108392volutions
ablations11311513ablations
ablution1047223ablution_
adulations11310123adulations
alations82518893_alations
allusions946013allusions
alluvions1254373alluvions
bilections14136503bilections
billions102211793bil_lions
calutrons1145503calutrons
cautions103313183_cautions
ciliations121111003ciliations
citations11312503citations
daltons8310403dal_t_ons
dealations11311373dealations
decurions1246023decurions
deductions1467133deductions
deflations1439713deflations
delation92318083delation_
deletion92011973deletion_
delusion937433delusion_
demotions1258443demotions
depilations14310903depilations
depletions1355743depletions
devolutions15106263devolutions
devotions1356593devotions
diatrons939613di_atrons
dictations1389703dictations
diction102313053di_ction_
diffusions1743743diffusions
digestions1246403digestions
dilatations1246413dilatations
dilating102714913dilati_ng
dilators93213203dilat_ors
diluters9288113dilut_ers
dilutes82911973dilut__es
dilutive1255383diluti_ve
dilutor8256013dilut_o_r
diluvian12194673diluvian_
diluviums1542503diluviums
diminutions1444543diminutions
directions1379643directions
disruptions14125683disruptions
dissolutions13144923dissolutions
disunion956113disunion_
diurons838823di_u_rons
divisions1396283divisions
divulsions1443343divulsions
donations101112353donations
dotations101411633dotations
durations10311463durations
durions839963d__urions
editions9310403edi__tions
elations83719123_elations
elusions82610083_elusions
elution72913823_elution_
epilations12311713epilations
evolutions13107043evolutions
fictions132410743fi_ctions
filiations13119093filiations
fixations1936353fixations
fluxions1844423_fluxions
gelations102513093gelations
gluttons944273_gluttons
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
illusions946213illusions
jillions15178283jil_lions
kilotons1286313kilot_ons
libations112510443libations
ligations102111993ligations
liquations1945623liquations
locutions11207063locutions
lotions74614763__lotions
millions101712433mil_lions
misunions1154533misunions
nidations1039213nidations
oblations1139373oblations
pillions101610923pil_lions
plutons938343_plut_ons
pollutions1245433pollutions
relations92418333relations
siltations1038553siltations
sinuations1039413sinuations
situations1038433situations
solations9814623solations
solution889593solution_
valuations1348783valuations
violations1337963violations
volitions1288663volitions
volutins1188003voluti_ns
volution1198603volution_
zillions17168073zil_lions

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411117.40620070.3
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.87222699.6
 
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.