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

156 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
desolates1031179(None) 
desolate9411991desolate_
desolated1139651desolated
desolater1038381desolater
desolaters1146041desolaters
dealates92716682de_alates
decollates13137152decollates
decorates12314742decorates
deflates123013942de_flates
defoliates1446332defoliates
delates83526282de__lates
depilates12310922depilates
derogates11310972derogates
desolately1443152desolately
desolator1046672desolator
desolators1146282desolators
detonates10310432detonates
insolates9311272insolates
isolates8613512_isolates
reslates83619502res_lates
resolutes968192resolutes
resonates9412402resonates
solates73523852__solates
absolutes1144523absolutes
aerolites9312583aerolites
apholates1449683apholates
bedplates1445493bedplates
cholates132414763_cholates
deaerates10313643deaerates
dealate83617843de_alate_
dealated103213603de_alated
debates103718533de__bates
decimates14410693decimates
declares11611313de_clares
decollate12137733decollate_
decollated14136283decollated
decolletes13123983decolletes
decorate11315193decorate_
decorated13312203decorated
dedicates13311693dedicates
defalcates1644543defalcates
defecates1538593defecates
defilades14134073defilades
deflate113613943de_flate_
deflated133412303de_flated
deflater123211603de_flater
deflaters13298703de_flaters
defoliate1346993defoliate_
defoliated1545833defoliated
deglazes1935463de_glazes
delate73827753de__late_
delated93722873de__lated
delegates1139843delegates
deletes83117933de__letes
delicates12314313delicates
demodulates1543753demodulates
demotes104717673demo__tes
denotes83817003deno__tes
denudates1145583denudates
depilate11311703depilate_
depilated1339653depilated
deplanes11311213de_planes
depletes112810643de_pletes
depopulates1644033depopulates
depurates1239823depurates
derates84028893de__rates
derivates13310093derivates
derogate10311353derogate_
derogated1238673derogated
desalinates1246213desalinates
desalted1038313desal_ted
desalter938363desal_ter
desalters1037673desal_ters
desalts839573desal_t_s
desecrates1348843desecrates
desiccates1545383desiccates
designates1246363designates
desolateness1354593desolateness
desolating1239463desolating
desolation11311403desolation
desolations12310593desolations
despites11410313des_pites
despumates1543543despumates
detonate9311193detonate_
detonated1138213detonated
devaluates14266063devaluates
deviates12312733de_viates
devolves15286263devol_ves
devotes113713753devo__tes
dilates83220663d__ilates
dislocates13108323dislocates
displaces1448593displaces
disrates91118153dis_rates
disulfates14145363disulfates
donates83217223d__onates
elates65032363_e__lates
emulates10312573_emulates
enolases8411013_enolases
epilates10313503_epilates
escalates1148823_escalates
estates74520183_es_tates
etiolates949213etiolates
evolutes1156063_evolutes
fellates11312753fe_llates
folates103218453__folates
gelates83219583ge__lates
gestates93213733ges_tates
hesitates1269793hesitates
immolates1346453immolates
insolate8311893insolate_
insolated1039713insolated
insulates9311843insulates
isolate7313923_isolate_
isolated9410523_isolated
messmates1346233messmates
neonates8310063ne_onates
obsoletes1144213obsoletes
peculates132112543peculates
percolates14410413percolates
perorates11417023perorates
personates122510693personates
phenolates1547013phenolates
pisolites1149383pisolites
reflates113115663re_flates
regelates10311113regelates
regulates101211723regulates
relates73731433re__lates
relocates11712933relocates
remolades1246563remolades
renovates1248453renovates
replates102919273re_plates
resalutes947433resalutes
resinates9314763resinates
reslate73520593res_late_
reslated93517523res_lated
resoles73823653resol__es
resolute868513resolute_
resoluter966183resoluter
resolutest1053923resolutest
resolves113010783resol_ves
resonate8513513resonate_
resonated10510613resonated
restates83423433res_tates
reviolates1347533reviolates
slates64934063__s_lates
solaces93116133__solaces
solate64526073__solate_
solated83618023__solated
solutes73515263__solutes
solvates11249673__solvates
templates1348273templates
tesselates1043933tesselates
testates83615453tes_tates
vesicates14119033vesicates
violates11311193_violates
zeolites1738383ze_olites

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.436409841.7
2DLD Change Limit1486411566.86021667.8
3Display Results1561560.0762052.6
 (SQL Overall)1786911567.37224239.1
 
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.