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

161 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
desolate941199(None) 
desolated1139651desolated
desolater1038381desolater
desolates10311791desolates
dealate83617842de_alate
decollate12137732decollate
decorate11315192decorate
deflate113613942de_flate
defoliate1346992defoliate
delate73827752de__late
depilate11311702depilate
derogate10311352derogate
desolately1443142desolately
desolaters1146042desolaters
desolator1046672desolator
detonate9311192detonate
insolate8311892insolate
isolate7313922_isolate
reslate73520592res_late
resolute868512resolute
resonate8513512resonate
solate64526072__solate
absolute1044483absolute
aerolite8315053aerolite
apholate13410473apholate
areolate81014453areolate
bedplate1346223bedplate
cholate122114933_cholate
deaerate9314173deaerate
dealated103213603de_alated
dealates92716683de_alates
debate94419193de__bate
decimate13411123decimate
declare10411223de_clare
decollated14136283decollated
decollates13137153decollates
decollete12124783decollete
decorated13312203decorated
decorates12314743decorates
dedicate12312803dedicate
defalcate1544923defalcate
defecate1438793defecate
defilade13124433defilade
deflated133412303de_flated
deflater123211603de_flater
deflates123013943de_flates
defoliated1545833defoliated
defoliates1446333defoliates
deglaze1835583de_glaze
delated93722873de__lated
delates83526283de__lates
delegate10410463delegate
delete73620703de__lete
delicate11315493delicate
demodulate1444023demodulate
demote94817803demo__te
denote74118043deno__te
dentate8315153de_ntate
denudate1046163denudate
depilated1339653depilated
depilates12310923depilates
deplane10311413de_plane
deplete103010413de_plete
depopulate1544413depopulate
depurate1139983depurate
derate74531233de__rate
derivate12311203derivate
derogated1238673derogated
derogates11310973derogates
desalinate1146673desalinate
desalt7518313desal_t_
desalted1038313desal_ted
desalter938363desal_ter
desalts839573desal_ts
desecrate1249083desecrate
desiccate1445923desiccate
designate1147113designate
desolating1239463desolating
desolation11311403desolation
desolators1146283desolators
desperate12410843desperate
despite10410123des_pite
despumate1443523despumate
detonated1138213detonated
detonates10310433detonates
devaluate13226363devaluate
deviate11312713de_viate
devolve14316063devol_ve
devote104513783devo__te
dilate73220693d__ilate
dislocate1289133dislocate
displace1348653displace
disrate81418523dis_rate
dissolute1045753dissolute
disulfate13145713disulfate
donate73619503d__onate
elate55335883_e__late
emulate9314123_emulate
enolase7310193_enolase
epilate9314283_epilate
escalate1039323_escalate
estate64719763_es_tate
etiolate849523etiolate
evolute1045683_evolute
fellate10313433fe_llate
folate93320393__folate
gelate73421253ge__late
gestate83614073ges_tate
hesitate1169973hesitate
immolate1246543immolate
insolated1039713insolated
insolates9311273insolates
insulate8312843insulate
isolated9410523_isolated
isolates8613513_isolates
messmate1246393messmate
neonate7311333ne_onate
obsolete1044313obsolete
peculate122414663peculate
percolate13411143percolate
perorate10417923perorate
personate112111423personate
petiolate1149143petiolate
phenolate1447473phenolate
pisolite10310373pisolite
prolate9419793_prolate
reflate103516263re_flate
regelate9312083regelate
regulate9313023regulate
relate64033633re__late
relocate10713533relocate
remolade1147203remolade
renovate1138553renovate
replate93420053re_plate
resalute857413resalute
resinate8316773resinate
reslated93517523res_lated
reslates83619503res_lates
resole64624183resol__e
resoluter966183resoluter
resolutes968193resolutes
resolve103910983resol_ve
resonated10510613resonated
resonates9412403resonates
restate73824883res_tate
reviolate1248123reviolate
revolute1176793revolute
rosulate8310903rosulate
slate55438283__s_late
solace83415823__solace
solated83618023__solated
solates73523853__solates
solute64016663__solute
solvate102710213__solvate
template1238433template
tesselate944183tesselate
testate73916233tes_tate
velate93720143ve__late
vesicate131210053vesicate
violate10311553_violate
zeolite1638903ze_olite

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621618.37317456.3
3Display Results1611610.0802012.5
 (SQL Overall)1786911618.62620715.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.