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

171 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
frothier143595(None) 
frother133110151froth_er
brother123311332broth_er
clothier1335362clothier
drouthier1343032drouthier
filthier1434072filthier
footier104115112foot_ier
frettier1156592frettier
froggier1354642froggier
frontier1147312frontier
frostier1148162frostier
frothed14288782froth_ed
frothers14279812froth_ers
frothiest1537452frothiest
frothily1745302frothily
frothing15208532frothing
frouzier2043702frouzier
frowsier1444892frowsier
frowzier2343312frowzier
grottier9316672grottier
growthier1642202growthier
mothier121910212_mothier
toothier1136422toothier
worthier1436712worthier
wrathier1435902wrathier
another10289153anoth_er
artier63419733ar_t_ier
artsier768943ar_tsier
blotchier1643213blotchier
blottier10336413blottier
botchier15287143_botchier
bother115218063_both_er
bothies12414783_bothies
brashier13389933brashier
brattier1047663brattier
breathier1435383breathier
bronzier1935633bronzier
broodier1157433broodier
broomier1236873broomier
brothel12318193broth_el
brothers133410833broth_ers
brownier13226913brownier
brushier13306973brushier
clothiers1443423clothiers
cottier93814173_cottier
couthier13218913couthier
croakier14436263croakier
crosier94116573cro_sier
croupier1246883croupier
crozier18369933cro_zier
dotier73917033_dot_ier
dottier83910923_dottier
droolier936073droolier
droopier1145573droopier
drossier956313drossier
drowsier1284903drowsier
earthier1137443earthier
farther1348343farth_er
father125116713f_ath_er
fattier103513463f_attier
feather133613503feath_er
featlier1136453featlier
fishier13359853f_ishier
flashier1437103flashier
fleshier1435603fleshier
floatier1136983floatier
flockier1745343flockier
floppier1554633floppier
flossier11326973flossier
flutier103011553flut_ier
flytier13356503flyt_ier
foamier12339003f_oamier
foggier12349913f_oggier
folkier14359043f_olkier
footer94320773foot__er
foothill1444993foothill
footie94718143foot_ie_
footies103721543foot_ies
footler104011873foot_ler
footsie1047653footsie_
footsies1139643footsies
forkier144311593f_orkier
forties104323863fort_ies
fortifier1546253fortifier
foxier163910033f_o_xier
fozier183710663f_o_zier
frater94520593frat__er
freakier15246483freakier
fresher132612643fresh_er
fretter103412753fret_ter
frier85225843fr___ier
frillier1136513frillier
fringier1236553fringier
friskier1535193friskier
fritter103912773frit_ter
frizzier19284813frizzier
fronter103611583fro_nter
frontiers1254993frontiers
froth115919283froth___
frothiness1645723frothiness
froths125411443froth__s
frothy15578373froth__y
frotteur1142503frotteur
frowner13429683fro_wner
frowstier1553143frowstier
fruitier1136593fruitier
frumpier1534173frumpier
further1337003furth_er
fustier104213933fust_ier
grittier9316263grittier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grouchier1543843grouchier
groutier9297173groutier
growlier1234883growlier
heathier1438343heathier
hootier104915353hoot_ier
knottier12203983knottier
lathier10310833_lathier
luthier1038233_luthier
mother113718643_moth_er
motlier92010583_motlier
mouthier13208173mouthier
mythier15125183_mythier
norther1039733north_er
nother93815963_noth_er
other84219103__oth_er
pithier123010293_pithier
plottier10327263plottier
portlier1038373portlier
pother113818853_poth_er
pottier93516493_pottier
prettier1069043prettier
prosier93817483pro_sier
rather94319743_rath_er
rattier74015593_rattier
ritzier16297203_ritzier
rockier134911883_rockier
roilier7311523_roilier
rookier114012383_rookier
roomier93812243_roomier
rootier74915393_rootier
ropier84118803_ro_pier
rosier64221263_ro_sier
rotifer1036993_rotifer
rotter64325463_rot_ter
roturier836033_roturier
roupier9319493_roupier
rowdier11348593_rowdier
rushier103411973_rushier
ruttier73412283_ruttier
sloshier1135283sloshier
smother123510213smoth_er
snottier8217383snottier
soother104215043sooth_er
sootier73916613soot_ier
spottier10207313spottier
torchier1337463torchier
tother94117143_toth_er
trashier113210103trashier
trophied1437643trophied
trophies13413673trophies
trothed114010973troth_ed
trothing122410843trothing
trotter73312253trot_ter
troutier8277153troutier
withier132910493_withier
worthies14310283worthies
writher134010853writh_er
zootier163611173zoot_ier

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621718.67316852.5
3Display Results1711710.0632714.3
 (SQL Overall)1786911719.15919509.9
 
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.