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

156 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
doughier133548(None) 
doughtier1443461doughtier
cougher133711732cough_er
couthier13218912couthier
daughter1344502daughter
dodgier10388242dodg_ier
doggier103810942do_ggier
doughiest1435782doughiest
droughtier1542612droughtier
drouthier1343032drouthier
druggier11134832druggier
mouthier13208172mouthier
pouchier1546802pouchier
rougher113511032rough_er
roughies1298322roughies
sloughier1343672sloughier
touchier1347382touchier
tougher114210982tough_er
toughie1187592toughie_
toughies1278242toughies
boggier113711583bo_ggier
botchier15287143botchier
boughed143810263bough_ed
boughten1444193boughten
bougie93613273boug_ie_
bougies103715183boug_ies
bouncier1236033bouncier
bouvier1277433bou_vier
brushier13306973brushier
buggier113611343_buggier
bushier123712813_bushier
coucher144515853couch_er
coughed143310903cough_ed
coughers14399963cough_ers
coughing15309213coughing
courier93617893cou_rier
courtier1059333courtier
couther123914633couth_er
couthie121810553couthie_
cushier123610833_cushier
danglier1056753danglier
dashier114311183d_ashier
daubier1037103dau_bier
daughters1443993daughters
dinghies1347363dinghies
dingier93513673ding_ier
dishier113613403d_ishier
dodger95817053dodg__er
dogger95216783do_g_ger
doggie93910893do_ggie_
doggies103613023do_ggies
doggoner1143873doggoner
dogie75222793do_g_ie_
dogies85022253do_g_ies
doomier103610123do_omier
dopier93515923do__pier
dorkier122810023do_rkier
dossier83711693do_ssier
dotier73917033do__tier
dottier83910923do_ttier
doubler103110083dou_bler
doubter10298353dou_bter
douche124613223douch_e_
douched144012113douch_ed
douches134315233douch_es
douching15349843douching
dough105217383dough___
doughboy1842293doughboy
doughlike1842683doughlike
doughnut1343563doughnut
doughs115912933dough__s
dought114915513dough__t
doughtiest1543233doughtiest
doughtily1742373doughtily
doughty15436023dough_ty
doughy14499843dough__y
dourer74215273dou__rer
douser75621633dou__ser
douzeper2042233douzeper
dowdier12328573do_wdier
downier11299703do_wnier
dozier163611633do__zier
draggier11135773draggier
draughtier1542443draughtier
dreggier1193553dreggier
druggie10134073druggie_
druggies11126223druggies
drumlier1134523drumlier
duchies133312313d_uchies
duckier143911793d_uckier
dumpier12409653d_umpier
dungier9368583d_ungier
duskier12409433d_uskier
dustier83814133d_ustier
foggier12349913fo_ggier
foughten1544003foughten
fuggier12348963_fuggier
gogglier1153923gogglier
gouger86014363goug__er
goutier82612353gou_tier
grouchier1543843grouchier
gushier113110073_gushier
haughtier1642743haughtier
jouncier1734423jouncier
laugher1136603laugh_er
laughter1245113laughter
loggier93811143lo_ggier
logier75015733lo_g_ier
loudlier934953loudlier
lousier72411623lou_sier
luthier1038233_luthier
mothier121910213mo_thier
mouldier1154963mouldier
mousier93712463mou_sier
mouther123812813mouth_er
muggier11288943_muggier
mushier123813593_mushier
naughtier1343103naughtier
oughted1236223_oughted
outlier72216143_outlier
plougher14214463plough_er
plushier1375193plushier
poachier1556823poachier
podgier11338723podg_ier
poutier93215323pou_tier
puggier11309383_puggier
pushier123611093_pushier
roughed124210943rough_ed
roughen11338833rough_en
roughers12329183rough_ers
roughhew1842873roughhew
roughing13278343roughing
roughish1545213roughish
roughleg1343403roughleg
roughrider1551843roughrider
roupier9319493rou_pier
rushier103411973_rushier
slouchier1443603slouchier
slushier1135983slushier
soggier93410883so_ggier
soughed123811623sough_ed
soughing13259733soughing
soupier93111753sou_pier
souther104116303south_er
toothier1136423toothier
torchier1337463torchier
toucher124814353touch_er
toughed123511693tough_ed
toughen11329203tough_en
toughener1344163toughener
toughing13278553toughing
toughish1545283toughish
uglier748953__uglier
voucher154110263vouch_er
vuggier12296813_vuggier
worthier1436713worthier

Search took 7 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.466383457.1
2DLD Change Limit1461621566.37622923.8
3Display Results1561560.0602600.0
 (SQL Overall)1786911566.90225889.7
 
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.