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

201 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
delicates1231431(None) 
dedicates13311691dedicates
delicate11315491delicate_
celibates1358632celibates
decimates14410692decimates
dedicate12312802dedicate_
dedicated14310252dedicated
dedicatee13410342dedicatee
dedicatees1445312dedicatees
defecates1538592defecates
delates83526282del__ates
delectates1348192delectates
delegates1139842delegates
delicacies1545132delicacies
delicately1644532delicately
delicts104012252delic_t_s
delineates1147122delineates
depilates12310922depilates
derivates13310092derivates
desiccates1545382desiccates
deviates12312732devi_ates
duplicates1546632duplicates
medicates14312112medicates
relocates11712932relocates
replicates1449452replicates
silicates11311522silicates
vellicates1545902vellicates
vesicates14119032vesicates
abdicates1448153abdicates
allocates11410473allocates
califates14310113califates
celibate1259313celibate_
cellmates1347513cellmates
ciliates10413453cili_ates
climates12311973_climates
colocates13312853colocates
deaerates10313643deaerates
dealates92716683de_alates
deaminates1349383deaminates
debates103718533de__bates
debilitates1444473debilitates
decades113615513de__cades
decanes103118913de__canes
decares102818533de__cares
deciares11510633deci_ares
decimate13411123decimate_
decimated1548953decimated
decorates12314743decorates
dedicator1348253dedicator
dedicators1447743dedicators
defalcates1644543defalcates
defecate1438793defecate_
defecated1637493defecated
deficits1447273deficit_s
defilades14134073defilades
deflates123013943de_flates
defoliates1446333defoli_ates
deices94119373de_ic__es
deicides1249303de_icides
delaminates1456903delaminates
delate73827753del__ate_
delated93722873del__ated
deleaves1248063del_eaves
delectate1248743delectate_
delectated1446723delectated
delegate10410463delegate_
delegated1238373delegated
delegatee1148803delegatee
delegatees1244273delegatees
deletes83117933del__etes
deliberates1446793deliberates
delicacy1644253delica_cy
delicatessen15151213delicatessen
delicious1246713delicious
delict94320333delic_t__
delighted1546203delighted
delighter1445583delighter
delighters1544363delighters
delights1347333delight_s
delimes10314193deli__mes
delimited1346593delimited
delimiter1246243delimiter
delimiters1345103delimiters
delimits1137573delimit_s
delineate1047793delineate_
delineated1246243delineated
delisted10310563deli_sted
delists84414173deli_st_s
demarcates1545973demarcates
denigrates1298113denigrates
denitrates1169513denitrates
denudates1145583denudates
depicted1437743depic_ted
depicter1356853depic_ter
depicters1435823depic_ters
depicts12358463depic_t_s
depilate11311703depilate_
depilated1339653depilated
deprecates1547283deprecates
depurates1239823depurates
derates84028893de__rates
derivate12311203derivate_
derogates11310973derogates
desalinates1246213desalinates
desecrates1348843desecrates
desiccate1445923desiccate_
desiccated1644993desiccated
designates1246363designates
desolates10311793desolates
detonates10310433detonates
detoxicates2154063detoxicates
deviate11312713devi_ate_
deviated13311043devi_ated
devices133212583devic__es
dictates11311383d__ictates
dilates83220663d__ilates
dislocates13108323dislocates
dominates12311743dominates
duplicate1447003duplicate_
duplicated1655833duplicated
educates1139623_educates
elates65032363_el__ates
elevates111110423_elevates
elicited1139093_elicited
elicits9311233_elicit_s
elites66027123_eli__tes
eluates72014683_el_uates
emirates101214853_emirates
epilates10313503_epilates
explicates2196663explicates
felicitates1644203felicitates
felicities1549743felicities
fellates11312753fel_lates
filiates11412663fili_ates
foliates11412753foli_ates
gelates83219593gel__ates
geminates12310043geminates
helices12313723helic__es
helicities1549853helicities
helictites1544653helictites
hellcats1346323hellcat_s
helpmates1645513helpmates
hesitates1269793hesitates
implicates1646783implicates
indelicate1345933indelicate_
indicates12312583indicates
kalifates1646133kalifates
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
ligates82318383__ligates
locates93218813__locates
loricates11310123loricates
mediates112814063medi_ates
medicares1446873medicares
medicate13513243medicate_
medicated15410073medicated
meditates1239813meditates
melilites1149193melilites
melinites11310413melinites
meliorates1288903meliorates
metricates1449123metricates
militates11310883militates
obligates12207853obligates
pelicans1238093pelica_ns
pelites93821993peli__tes
placates12311753_placates
plicate11314513_plicate_
plicated13310643_plicated
predicates15410823predicates
prelocates1468353prelocates
radicates12412073radicates
rededicates15115073rededicates
redictates1348233redictates
relates73731433rel__ates
relegates10310943relegates
relicts94414593relic_t_s
relocate10713533relocate_
relocated12710813relocated
relocatee11810633relocatee
relocatees1275223relocatees
reluctates1246703reluctates
replicases1444673replicases
replicate13410043replicate_
replicated1548773replicated
resinates9314763resinates
salivates1239293salivates
selenates91611363selenates
seriates82620673seri_ates
silicate10312623silicate_
sonicates11410383sonicates
suricates11311743suricates
tunicates11268743tunicates
urticates1148893urticates
validates1338243validates
velites103417303veli__tes
vellicate1446433vellicate_
vellicated1644803vellicated
veritates12310973veritates
vesicate131210053vesicate_
vesicated15117653vesicated

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.420425454.8
2DLD Change Limit1486412017.11020905.9
3Display Results2012010.0802512.5
 (SQL Overall)1786912017.61023481.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.