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

108 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
distillation134774(None) 
distillations1446941distillations
instillation1245852instillation
redistillation1563032redistillation
titillation1145042ti_tillation
cantillation1446693cantillation
destination12413843desti_nation
disillusion1252393dis_illusion
disinflation1656583disinflation
disrelation1248813dis_relation
dissimilation1656523dissimilation
dissimulation1655373dissimulation
dissipation1447213dissi_pation
distillate1146743distillat__e
distillates1246153distillat_es
distinction1447323disti_nction
fibrillation1753523fibrillation
installation1254913installation
instillations1344923instillations
oscillation1345503_oscillation
redistillations1672913redistillations
scintillation1593003scintillation
titillations1244443ti_tillations
aestivation1447924aesti_vation
cantillations1545734cantillations
castigation1447974casti_gation
constellation1554804constellation
decollation1448194d_ecollation
defibrillation2061904defibrillation
denticulation1654564denticulation
depilation13312034d_epi_lation
desalination13411134desalination
desiccation1646384des_iccation
designation1347484des_ignation
desolation11311404des__olation
despoliation1546714despoliation
destinations13412664desti_nations
destitution1255544desti_tution
dictation12810564dict___ation
dieselization2356054dieselization
digitization2347684digitization
dilation92215464d___i_lation
disaffiliation2163334disaffiliation
disarticulation1863574disarticulation
disclamation1754244disclamation
discoloration16124724discoloration
disillusions1352324dis_illusions
disinflations1756294disinflations
dislocation14147504dis_location
dispensation1555604dispensation
disputation14116744dis_putation
disrelations1348504dis_relations
dissertation1366094dissertation
dissimilations1755864dissimilations
dissimulations1754904dissimulations
dissipations1546534dissi_pations
dissociation1556644dissociation
dissolution12145024dis_solution
distention11158874dist__ention
distilleries1352834distilleries
distilling1247794distill__ing
distinctions1557324disti_nctions
distortion1146694dist__ortion
distraction1449114dist_raction
distribution1555364distribution
divination14139234di_vi_nation
estimation12410844_esti_mation
estivation1349814_esti_vation
etiolation1048534__etiolation
fibrillations1853104fibrillations
fustigation1545214fusti_gation
gastrulation1353834gastrulation
gesticulation1694704gesticulation
illation8311944____illation
installations1354224installations
instigation1249244insti_gation
intimation12413044_inti_mation
isolation9311644_is__olation
litigation1148174li_ti_gation
mastication15610294masti_cation
miscitation1547774misci_tation
misutilization25155484misutilization
mitigation1348644mi_ti_gation
mutilation1249754_muti_lation
oscillations1445124_oscillations
pistillate1245444pistillat__e
pixilation1945914pi_xi_lation
postillion1255644postill__ion
postisolation1553574postisolation
postulation13119134post_ulation
pustulation13116624pust_ulation
reinstallation1462434reinstallation
restimulation1555384restimulation
rustication1349224rusti_cation
scintillations1662754scintillations
sibilation12128774si_bi_lation
siltation939214__s_iltation
spallation1247024__spallation
stimulation1377224__stimulation
stipulation1356334__stipulation
tessellation1252794tessellation
titillating1243714ti_tillating
titillative1452464ti_tillative
titivation1347034ti_ti_vation
vacillation1645324_vacillation
ventilation1448164venti_lation
visitation1348594vis_i_tation
vitiation1239564vi_ti__ation

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901088.17015274.2
3Display Results1081080.0631714.3
 (SQL Overall)1786911088.62320722.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.