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

216 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
delicate1131549(None) 
dedicate12312801dedicate
delicates12314311delicates
celibate1259312celibate
decimate13411122decimate
dedicated14310252dedicated
dedicatee13410342dedicatee
dedicates13311692dedicates
defecate1438792defecate
delate73827752del__ate
delectate1248742delectate
delegate10410462delegate
delicacy1644252delicacy
delicately1644532delicately
delict94320332delic_t_
delicts104012252delic_ts
delineate1047792delineate
depilate11311702depilate
derivate12311202derivate
desiccate1445922desiccate
deviate11312712devi_ate
duplicate1447002duplicate
indelicate1345932indelicate
medicate13513242medicate
plicate11314512_plicate
relocate10713532relocate
replicate13410042replicate
silicate10312622silicate
vellicate1446432vellicate
vesicate131210052vesicate
abdicate1348903abdicate
allocate10411023allocate
califate13310483califate
calycate1537893calycate
celibates1358633celibates
cellmate1237863cellmate
ciliate9514603cili_ate
climate11312833_climate
colocate12313433colocate
deaerate9314173deaerate
dealate83617843de_alate
deaminate12410173deaminate
debate94419193de__bate
debilitate1344863debilitate
decade104216163de__cade
decane93818873de__cane
decare93919153de__care
deciare10710663deci_are
deciduate1345063deciduate
decimated1548953decimated
decimates14410693decimates
decorate11315193decorate
dedicatees1445313dedicatees
dedicator1348253dedicator
defalcate1544923defalcate
defecated1637493defecated
defecates1538593defecates
deficit1339673deficit_
deficits1447273deficits
defilade13124433defilade
definite1239323definite
deflate113613943de_flate
defoliate1346993defoli_ate
deice84320033de_ic__e
deicide1149403de_icide
delaminate1347373delaminate
delated93722873del__ated
delates83526283del__ates
deleave1147723del_eave
delectated1446723delectated
delectates1348193delectates
delegated1238373delegated
delegatee1148803delegatee
delegates1139843delegates
delete73620703del__ete
deliberate1347123deliberate
delicacies1545133delicacies
delight12610673delight_
delighted1546203delighted
delighter1445583delighter
delights1347333delights
delime9314043deli__me
delimit10311733delimit_
delimited1346593delimited
delimiter1246243delimiter
delimits1137573delimits
delineated1246243delineated
delineates1147123delineates
delist74625053deli_st_
delisted10310563deli_sted
delists84414173deli_sts
demarcate1446613demarcate
denigrate1168693denigrate
denitrate10810533denitrate
dentate8315153de_ntate
denudate1046163denudate
depict113514793depic_t_
depicted1437743depic_ted
depicter1356853depic_ter
depicts12358463depic_ts
depilated1339653depilated
depilates12310923depilates
deprecate1477433deprecate
depurate1139983depurate
derate74531233de__rate
derivates13310093derivates
derogate10311353derogate
desalinate1146673desalinate
desecrate1249083desecrate
desiccated1644993desiccated
desiccates1545383desiccates
designate1147113designate
desolate9411993desolate
detonate9311193detonate
detoxicate2054483detoxicate
deviated13311043devi_ated
deviates12312733devi_ates
device124512163devic__e
dictate10311663d__ictate
digitate1098683digitate
dilatate947773dilatate
dilate73220693d__ilate
dislocate1289133dislocate
dominate11312853dominate
duplicated1655833duplicated
duplicates1546633duplicates
educate10310213_educate
elate55335883_el__ate
elevate101110373_elevate
elicit8417203_elicit_
elicited1139093_elicited
elicits9311233_elicits
elite56230183_eli__te
eluate62315433_el_uate
emirate91015833_emirate
epilate9314283_epilate
explicate20117493explicate
falcate12311613fal_cate
felicitate1544463felicitate
felicity1647913felicity
fellate10313433fel_late
filiate10414233fili_ate
foliate10513533foli_ate
gelate73421253gel__ate
geminate11411803geminate
helical12311153helica_l
helicity1648503helicity
helictite1445973helictite
hellcat12410173hellcat_
hellcats1346323hellcats
helpmate1545603helpmate
hesitate1169973hesitate
implicate1547273implicate
indicate11313353indicate
kalifate1556493kalifate
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
ligate72519253__ligate
locate83919843__locate
loricate10310663loricate
mediate103415213medi_ate
medicare1347483medicare
medicated15410073medicated
medicates14312113medicates
meditate11310623meditate
melilite10410573melilite
melinite10411743melinite
meliorate1179483meliorate
meniscate1346213meniscate
metricate1349913metricate
militate10311673militate
muricate12311113muricate
obligate11198303obligate
pelican1139433pelica_n
pelicans1238093pelicans
pelite84323003peli__te
peltate92013773pel_tate
placate11312433_placate
plicae10410953_plica_e
plicated13310643_plicated
predicate14411773predicate
prelocate13109513prelocate
radicate11412873radicate
reclinate11410023reclinate
rededicate14125573rededicate
redictate1249063redictate
relate64033633rel__ate
relegate9311243relegate
relict83623903relic_t_
relicts94414593relic_ts
relocated12710813relocated
relocatee11810633relocatee
relocates11712933relocates
reluctate1146923reluctate
replicase1344803replicase
replicated1548773replicated
replicates1449453replicates
resinate8316773resinate
salivate11310013salivate
selenate81712523selenate
seriate73722473seri_ate
silicates11311523silicates
sonicate10310933sonicate
spicate113214193_spicate
sulcate9314423sul_cate
suricate10312613suricate
tunicate103310043tunicate
urticate1049863urticate
validate1239003validate
velate93720143vel__ate
vellicated1644803vellicated
vellicates1545903vellicates
vesicae12177703vesica_e
vesicated15117653vesicated
vesicates14119033vesicates

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622167.64019131.2
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.89322639.2
 
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.