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

206 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
draftier128526(None) 
craftier1376191craftier
draffier1574321draffier
drafter11449431draft_er
driftier1275121driftier
brattier1047662brattier
crafter124111332craft_er
daffier1457832d_affier
dafter104813342d_aft_er
drafted12439032draft_ed
draftee11379522draft_ee
draftees12225252draftees
drafters12338532draft_ers
draftiest1335942draftiest
draftily1534412draftily
drafting13339412drafting
draggier11135772draggier
drawlier12225252drawlier
drifter11348702drift_er
grafter114211152graft_er
rafter94517582_raft_er
rattier74015592_rattier
after85719793__aft_er
artier63419733__artier
battier93515713_battier
blastier10249493blastier
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
cattier93317073_cattier
chaffier1935473chaffier
chattier1337513chattier
crabbier14326803crabbier
crafted13419773craft_ed
crafters13419953craft_ers
craftiest1436913craftiest
craftily1644783craftily
crafting143710173crafting
craggier12116063craggier
crampier14288903crampier
crankier14339163crankier
crappier14288133crappier
crater85026643cra_t_er
crawlier13216873crawlier
crazier183610743cra_zier
crofter12299573croft_er
crustier10259533crustier
daintier937403daintier
dallier84215373d_allier
dandier93714573d_andier
darklier1335013darklier
darter75320363d_art_er
dashier114311183d_ashier
dater65332313d_a_t_er
daubier1037103d_aubier
dautie72914703d_autie_
dauties83315763d_auties
dawtie103011093d_awtie_
dawties113312703d_awties
deadlier1036863deadlier
deafer104114813deaf__er
defier105118653d_ef_ier
defter104215923d_eft_er
deifier113013123deif_ier
diaster82813313diast_er
dictier103411863d_ictier
dirtier83312093d_irtier
dotier73917033d__otier
dottier83910923d_ottier
drabber12438593dra_bber
draffiest1644363draffiest
draffish1844553draffish
draft95526683draft___
draftiness1444863draftiness
draftings14334213draftings
drafts105012533draft__s
draftsmen1552673draftsmen
drafty13638933draft__y
dragger10309173dra_gger
dragster1034633dragster
drainer83012843dra_iner
draper94315693dra__per
drastic10310883drasti_c
dratted9358593dra_tted
dratting10389663dratting
draughtier1542443draughtier
drawer104711363dra__wer
drawler11338593dra_wler
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dressier956863dressier
drier64423963dr___ier
drifted12367953drift_ed
drifters12417913drift_ers
driftiest1335943driftiest
drifting13338733drifting
drippier1385043drippier
droolier936073droolier
droopier1145573droopier
drossier956313drossier
drouthier1343033drouthier
drowsier1284903drowsier
druggier11134833druggier
drumlier1134523drumlier
dustier83814133d_ustier
fattier103513463_fattier
frater94520593fra_t_er
frettier1156593frettier
frontier1147313frontier
frostier1148163frostier
fruitier1136593fruitier
gnattier934263gnattier
grabbier13316653grabbier
grafted124110223graft_ed
grafters12409193graft_ers
grafting13319623grafting
grainier9218903grainier
granter84117133grant_er
grapier103712603gra_pier
grassier9349283grassier
grater74625443gra_t_er
grazier173611133gra_zier
grifter113810493grift_er
grittier9316263grittier
grottier9316673grottier
groutier9297173groutier
gruffier1544703gruffier
hafter124815883_haft_er
hastier103916623_hastier
heartier1139093heartier
heftier1337203_heftier
irater65218353ira_t_er
krater104014313kra_t_er
leafier10329833leaf_ier
loftier1037763_loftier
maftir1136493_mafti_r
maltier93015483_maltier
matier84321523_ma_tier
meatier93214613mea_tier
nastier74115293_nastier
nattier73614623_nattier
niftier10328713_niftier
orangier947713orangier
partier93520713_partier
pastier94320383_pastier
peatier94017233pea_tier
platier93716293pla_tier
practicer1544593practicer
prater84825353pra_t_er
prattler10166343prattler
prettier1069043prettier
profiter132710203profiter
quartier1737543quartier
racier85120973_ra_cier
raffler13339223_raffler
rafted104714703_raft_ed
rafters103715633_raft_ers
rafting113815753_rafting
rainier71614263_rainier
rallier73816273_rallier
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
ranter63826823_rant_er
rapier84019993_ra_pier
raspier93110643_raspier
raster64731443_rast_er
rater54943283_ra_t_er
rather94319743_ra_ther
ratter64326313_ra_tter
rattler74012743_rattler
rentier73618223_rentier
rootier74915393_rootier
runtier73512853_runtier
rustier74416363_rustier
ruttier73412283_ruttier
saltier74318633_saltier
scantier10309983scantier
scattier10267583scattier
shiftier1436343shiftier
slatier74016813sla_tier
tartier74123263_tartier
tastier711817093_tastier
tattier74216243_tattier
thriftier1542853thriftier
toastier846893toastier
trampier12318243trampier
trashier113210103trashier
troutier8277153troutier
trustier8268683trustier
tuftier1096603_tuftier
vastier103613203_vastier
wafter124114613_waft_er
wartier103413913_wartier
wiftier13297733_wiftier
wrathier1435903wrathier
wristier1136863wristier
yeastier1135393yeastier

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.406440125.6
2DLD Change Limit1461622067.28020077.2
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.76623009.4
 
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.