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

101 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
denticulate144551(None) 
denticulated1654391denticulated
geniculate1345812gen_iculate
gesticulate1445662gesticulate
reticulate12219782re_ticulate
articulate12410243_articulate
denticle1137773dentic_l__e
denticulation1654563denticulation
geniculated1544643gen_iculated
gesticulated1654543gesticulated
gesticulates1555043gesticulates
lenticular1254393lenticula_r
lenticule1144273lenticul__e
paniculate1447213pan_iculate
particulate1548313particulate
pediculate1546613pe_diculate
rearticulate1455043rearticulate
restimulate1365843restimulate
reticulated14127783re_ticulated
reticulates13148873re_ticulates
ventilate1248383venti__late
vermiculate1855723vermiculate
vesiculate1547223ve_siculate
aciculate132510804__aciculate
anticipate1467734_anticipate
anticult10411684_anticul_t_
anticults1159374_anticul_ts
antiquate1888034_antiqu_ate
apiculate13279884__apiculate
articulated1447624_articulated
articulates1349044_articulates
auriculate1246494_auriculate
cantillate1247344canti_llate
continuate1248334continu_ate
cuticulae1344264_cuticula_e
deciduate1345064de_cidu_ate
dedicate12312804de_dic__ate
delicate11315494de_lic__ate
demodulate1444024de_modulate
denigrate1168694den_i_grate
denitrate10810534den_i_trate
dentate8315154dent____ate
denticles1237754dentic_l_es
denticulations1753914denticulations
denudate1046164den___udate
depilate11311704de_pi__late
depopulate1544414de_populate
deregulate12135194de_regulate
desiccate1445924de_sic_cate
destitute1046884destitu__te
disarticulate1673844disarticulate
dissimulate14114974dissimulate
distillate1146744disti_llate
ejaculate18187164_e_jaculate
emasculate1445554_emasculate
etiolate849524_e_ti_olate
fasciculate1854004fasciculate
gesticulant1453074gesticulant
gesticulative1962954gesticulative
gesticulator1553794gesticulator
inarticulate1454564inarticulate
inoculate1149624_in_oculate
inosculate1245924_inosculate
lenticules1244414lenticul_es
mandibulate1652844mandibulate
manipulate1445164man_ipulate
matriculate1546194matriculate
monticule1344714monticul__e
orbiculate1445184_orbiculate
particulates1647364particulates
peculate122414674pe___culate
pediculates1645684pe_diculates
pedunculate1652304pedunculate
penicillate1563054pen_icillate
petiolate1149154pe_ti_olate
rearticulated1654154rearticulated
rearticulates1554624rearticulates
recalculate15135384recalculate
recirculate1554704recirculate
reinoculate1354784reinoculate
restimulated1564904restimulated
restimulates1465314restimulates
reticula1047414re_ticula__
reticular1147114re_ticula_r
reticulately1753074re_ticulately
reticule1049304re_ticul__e
retinulae945364re_tinula_e
spiculate132210164__spiculate
stimulate1148234__stimulate
stipulate1147324__stipulate
tentacular1253484tentacula_r
testicular1254554testicula_r
ventilated1446364venti__lated
ventilates1347604venti__lates
ventricular1653834ventricula_r
vermiculated2064514vermiculated
vermiculite1853554vermiculite
verticillate1752164verticillate
vesiculae1445204ve_sicula_e
vesiculated1745554ve_siculated
vesiculates1646294ve_siculates

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191019.33015950.6
3Display Results1011010.0601683.3
 (SQL Overall)1786911019.81318209.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.