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

152 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
craftiest143691(None) 
draftiest1335941draftiest
brattiest1148102brattiest
cattiest103016332c_attiest
chaffiest2045422chaffiest
chattiest1448212chattiest
crabbiest1535622crabbiest
craftier1376192craftie_r
craftiness1545752craftiness
craggiest13116522craggiest
crampiest15268622crampiest
crankiest1538822crankiest
crappiest15267272crappiest
crawliest14187402crawliest
craziest19319922cra_ziest
crustiest112410052crustiest
draffiest1644362draffiest
driftiest1335942driftiest
rattiest83516112_rattiest
artiest73121993__artiest
battiest104115553_battiest
blastiest111710053blastiest
braggiest13116783braggiest
brainiest11209723brainiest
brakiest143912243bra_kiest
branniest11199383branniest
brashiest14359863brashiest
brassiest11369713brassiest
brawliest14177193brawliest
brawniest14197103brawniest
cagiest102916433c_a_giest
cakiest133215663c_a_kiest
campiest142212143c_ampiest
canniest10313363c_anniest
carrotiest1245663carrotiest
catties94023053c_atties_
chalkiest1837093chalkiest
chanciest1638383chanciest
chanties132615803chanties_
chariest13315513cha_riest
charriest1438263charriest
chartist131112133charti_st
chastest1349703chast_est
chertiest1438793chertiest
chestiest1438313chestiest
chuffiest2044403chuffiest
clammiest1535743clammiest
clankiest1536673clankiest
classiest11309553classiest
clayiest1337923cla_yiest
cliffiest1743953cliffiest
coaliest10316223coa_liest
coattest1038863coa_ttest
comfiest1539133comf_iest
crackliest1844883crackliest
crafted13419773craft_e_d
crafter124111333craft_e_r
crafters13419953craft_ers
craftily1644783crafti_ly
crafting143710173crafti_ng
crafts115312743craft__s_
crankest1438143cra_nkest
crannies10313013crannies_
crappies142911163crappies_
crassest103411523cra_ssest
crates85736063cra_t_es_
crazies183413853cra_zies_
creakiest15238593creakiest
creamiest13248933creamiest
creasiest11229943creasiest
creepiest1337063creepiest
crepiest12310383cr_epiest
crimpiest15237183crimpiest
crispiest13197423crispiest
croakiest15167173croakiest
croupiest1337063croupiest
cruddiest1334453cruddiest
crumbiest1536253crumbiest
crummiest1545563crummiest
daffiest1537843_daffiest
daftest11248943_daft_est
draftees12225253draftees_
draftier1285263draftie_r
draftiness1444863draftiness
draggiest12126413draggiest
drawliest13166243drawliest
fattiest113514313_fattiest
frettiest1267063frettiest
frostiest1239213frostiest
fruitiest1237383fruitiest
gnattiest1035383gnattiest
grabbiest1435323grabbiest
grainiest10188993grainiest
grapiest112211933gra_piest
grassiest10309513grassiest
grittiest10176983grittiest
grottiest10147183grottiest
groutiest10147763groutiest
gruffiest1634533gruffiest
hastiest112916503_hastiest
heartiest12311103heartiest
heftiest1439183_heftiest
iratest7312483ira_t_est
leafiest113410893leaf_iest
loftiest1139083_loftiest
maltiest102916193_maltiest
matiest92522453_ma_tiest
meatiest102816793mea_tiest
nastiest83615953_nastiest
nattiest83215353_nattiest
niftiest112910073_niftiest
orangiest1038463orangiest
pastiest103319553_pastiest
peatiest103118813pea_tiest
platiest103216093pla_tiest
prettiest1199803prettiest
raciest92820013_ra_ciest
rainiest81214923_rainiest
rammiest12299933_rammiest
randiest93418773_randiest
rangiest93115983_rangiest
raspiest10311283_raspiest
rootiest83115593_rootiest
runtiest83014513_runtiest
rustiest83116803_rustiest
ruttiest82712663_ruttiest
saltiest83117723_saltiest
scantiest112611013scantiest
scattiest11268373scattiest
scraggiest1444373scraggiest
scrappiest1644163scrappiest
scrawliest1553823scrawliest
scrawniest1543493scrawniest
scruffiest1842933scruffiest
shiftiest1537373shiftiest
slatiest82616273sla_tiest
tartiest82718313_tartiest
tastiest83216633_tastiest
tattiest83415383_tattiest
thriftiest1643113thriftiest
toastiest937423toastiest
trampiest13227903trampiest
trashiest123110643trashiest
troutiest9127803troutiest
trustiest9239083trustiest
tuftiest1138283_tuftiest
vastiest112713073_vastiest
wartiest113614643_wartiest
wiftiest14279173_wiftiest
wrathiest1536983wrathiest
wristiest1237753wristiest
yeastiest1237203yeastiest

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.423422437.4
2DLD Change Limit1486411527.40620070.3
3Display Results1521520.0762000.0
 (SQL Overall)1786911527.90522604.8
 
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.