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 “distillations” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
distillations144694(None) 
distillation1347741distillation_
instillations1344922instillations
redistillations1672912redistillations
titillations1244442ti_tillations
cantillations1545733cantillations
destinations13412663desti_nations
disillusions1352323dis_illusions
disinflations1756293disinflations
disrelations1348503dis_relations
dissimilations1755863dissimilations
dissimulations1754903dissimulations
dissipations1546533dissi_pations
distillates1246153distillat__es
distinctions1557323disti_nctions
fibrillations1853103fibrillations
installations1354223installations
instillation1245853instillation_
oscillations1445123_oscillations
redistillation1563033redistillation_
scintillations1662753scintillations
titillation1145043ti_tillation_
aestivations1547484aesti_vations
cantillation1446694cantillation_
castigations1547204casti_gations
constellations1654404constellations
decollations1547364d_ecollations
defibrillations2161694defibrillations
denticulations1753914denticulations
depilations14310904d_epi_lations
desalinations14410184desalinations
desiccations1755654des_iccations
designations1456944des_ignations
desolations12310594des__olations
despoliations1646394despoliations
destination12413844desti_nation_
destitutions1385254desti_tutions
dictations1389704dict___ations
dieselizations2455914dieselizations
digitizations2447084digitizations
dilations102614454d___i_lations
disaffiliations2263014disaffiliations
disclamations1853724disclamations
discolorations17104304discolorations
disillusion1252394dis_illusion_
disinflation1656584disinflation_
dislocations15136984dis_locations
dispensations1655484dispensations
disputations15106174dis_putations
disrelation1248814dis_relation_
dissertations1465894dissertations
dissimilation1656524dissimilation_
dissimulation1655374dissimulation_
dissipation1447214dissi_pation_
dissociations1656014dissociations
dissolutions13144924dis_solutions
distentions12178844dist__entions
distillate1146744distillat___e
distilleries1352834distilleri_es
distilling1247794distill__i_ng
distinction1447324disti_nction_
distortions1246614dist__ortions
distractions1548754dist_ractions
distributions1665124distributions
divinations15128414di_vi_nations
estimations1349944_esti_mations
estivations1449274_esti_vations
etiolations1147394__etiolations
fibrillation1753524fibrillation_
fustigations1644764fusti_gations
gastrulations1463644gastrulations
gesticulations1784114gesticulations
illations9311394____illations
installation1254914installation_
instigations1348244insti_gations
intimations13411884_inti_mations
isolations10310694_is__olations
litigations1247334li_ti_gations
mastications1649414masti_cations
miscitations1647054misci_tations
misutilizations26145154misutilizations
mitigations1447624mi_ti_gations
mutilations1348644_muti_lations
oscillation1345504_oscillation_
pixilations2045334pi_xi_lations
postillions1354554postill__ions
postulations14127734post_ulations
pustulations14115624pust_ulations
reinstallations1562154reinstallations
restimulations1654644restimulations
rustications1448564rusti_cations
scintillation1593004scintillation_
sibilations13127934si_bi_lations
siltations1038554__s_iltations
spallations1356104__spallations
stimulations1456204__stimulations
stipulations1455444__stipulations
tessellations1352644tessellations
titillating1243714ti_tillati_ng
titivations1446264ti_ti_vations
vacillations1744884_vacillations
ventilations1547404venti_lations
visitations1447674vis_i_tations
vitiations1338744vi_ti__ations

Search took 6 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 Filter178691950240.356501941.0
2DLD Change Limit950241044.73620064.2
3Display Results1041040.0631650.8
 (SQL Overall)1786911045.15534663.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.