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

455 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
frother13311015(None) 
brother123311331brother
frothed14288781frothed
frothers14279811frothers
frothier1435951frothier
another10289152another
bother115218062_bother
brothel12318192brothel
brothers133410832brothers
farther1348342farther
father125116712f_ather
feather133613502feather
footer94320772foot_er
footier104115112footier
footler104011872footler
frater94520592frat_er
fresher132612642fresher
fretter103412752fretter
fritter103912772fritter
fronter103611582fronter
frontier1147312frontier
frostier1148162frostier
froth115919282froth__
froths125411442froth_s
frothy15578372froth_y
frotteur1142502frotteur
frowner13429682frowner
further1337002further
mother113718642_mother
norther1039732norther
nother93815962_nother
other84219102__other
pother113818852_pother
rather94319742_rather
rotter64325462_rotter
smother123510212smother
soother104215042soother
tother94117142_tother
trothed114010972trothed
trotter73312252trotter
writher134010852writher
aether94213673_aether
anther93715063_anther
apothem1444643apothem
archer115016243ar_cher
arouser74514423arouser
artier63419733ar_tier
bather115322513_bather
blather125314213blather
blether12459913blether
blither124812173blither
blotter94612853blotter
botcher143613223_botcher
bothers124317753_bothers
brasher124515243brasher
breather133610593breather
broacher15329263broacher
broader103412613broader
broche133612103broche_
broider103912973broider
broiler92911753broiler
broker124314243bro_ker
bronzer18348493bronzer
brooder103811623brooder
broth106521093broth__
brothels13277073brothels
brothered1546003brothered
brotherly1743793brotherly
broths115013923broth_s
brothy14519623broth_y
browner124911643browner
browser124911143browser
brusher123813003brusher
cither114616683_cither
clothe114712993clothe_
clothed134010283clothed
clothes124513813clothes
clothier1335363clothier
cooter85128613coot_er
cosher114819903_cosher
cotter84926673_cotter
couther123914633couther
crasher124616163crasher
crater85026643crat_er
critter94113033critter
croaker133010683croaker
crochet143616663crochet
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropper133312973cropper
crosier94116583crosier
crosser95015473crosser
crotched16428603crotched
crotches153411303crotches
crotchet152711993crotchet
crowder13389863crowder
crower114117563cro_wer
crowner124012603crowner
crozer175112843cro_zer
crozier18369943crozier
crusher124412323crusher
diether1147443diether
dither104417683_dither
doter65428623_dot_er
dotier73917033_dotier
dotter74419343_dotter
droller84110283droller
droner74717673dro_ner
dropper12329873dropper
drouthier1343033drouthier
drover104614593dro_ver
drowner11369803drowner
druthers1275793druthers
either94517423_either
emoter85415193emot_er
ether84518773__ether
fagoter1135883fagot_er
faithed1437163faithed
falter94519053falt_er
faster94625773fast_er
fathers133916503f_athers
fatter94523213f_atter
fattier103513463fattier
feater95224053feat_er
feathers143513243feathers
feathery17368073feathery
feoffer1233023feoffer
fester94723513fest_er
fetcher153510393fetcher
fetter94120383f_etter
fighter143010773fighter
filcher15377793filcher
filter94517633filt_er
filthier1434073filthier
fisher124917143f_isher
fitter94120033f_itter
flasher133914063flasher
flatter103815963flatter
flesher133610923flesher
fletcher16306663fletcher
flitter103413903flitter
floater104413353floater
floatier1136983floatier
flogger12449463flogger
flooder11258463flooder
floorer10248073floorer
flopper14328473flopper
flosser10339693flosser
flouter104311343flouter
flower124815503flo_wer
flusher133012273flusher
fluter95316863flut_er
flutier103011553flutier
flutter104012093flutter
flytier13356503flytier
foamer114714313f_oamer
fodder114712113f_odder
fogger114414783f_ogger
folder104317543f_older
fonder104120063f_onder
footed104418623foot_ed
footers104618333foot_ers
footgear12113063footgear
footie94718143footie_
footies103721543footies
footle93914383footle_
footled113610763footled
footlers113910793footlers
footles103715713footles
footmen1246583footmen
footwear14103373footwear
foozler19397593foozler
forager114412563forager
forayer13368953forayer
forcer114917343f_orcer
foremother1843483foremother
forever1338953forever
forgather1643663forgather
forger104820773f_orger
forgoer1137693forgoer
forker134717903f_orker
forkier144311593forkier
former114221403f_ormer
forte86131463fort_e_
fortes95327183fort_es
forth116222673forth__
forties104323863forties
foster94322223f_oster
fouler93614903f_ouler
fowler123712583f_owler
foxier163910033f_oxier
foyer116416553f_o_yer
fozier183710663f_ozier
frailer10319943frailer
framer114817443fr_amer
franker143510183franker
fraters103517213frat_ers
freer86021243fr__eer
freezer19348523freezer
freshed143312593freshed
freshen133010883freshen
freshes133515823freshes
freshet133416643freshet
fretted113411853fretted
fretters113410303fretters
frettier1156593frettier
frier85225843fr__ier
friller104111743friller
frisker14389273frisker
frites94922483frit_es
frith115922033frith__
friths124313583frith_s
fritted113611333fritted
fritters113810783fritters
fritzes19329453fritzes
frizer184011283fr_izer
frizzer18446893frizzer
frocked17439333frocked
froe75329993fro__e_
froes86126693fro__es
frogged13408493frogged
froggier1354643froggier
froglet11310063froglet
frogmen1335893frogmen
fronded12388863fronded
frondeur1242793frondeur
fronted114011273fronted
frontes104214163frontes
frontiers1254993frontiers
frontlet1147653frontlet
frontmen1344423frontmen
frore86218803fro_re_
frosh115713403frosh__
frosted113211883frosted
frothiest1537453frothiest
frothily1745303frothily
frothing15208533frothing
frotteurs1242223frotteurs
frouzier2043703frouzier
frowned14348833frowned
frowners14377933frowners
frowsier1444903frowsier
frowstier1553143frowstier
frowzier2343313frowzier
froze174515653fro_ze_
frozen18408443fro_zen
fruiter10309683fruiter
fruitier1136593fruitier
fryer115913433fr__yer
furthers1436493furthers
fustier104213933fustier
garotter965953garotter
gather104115863_gather
gopher1239183_gopher
grater74625443grat_er
gritter83913353gritter
groaner82510133groaner
grocer94212143gro_cer
grodier939673grodier
groomer10399873groomer
groover11358543groover
groper94517253gro_per
grosser84313143grosser
grottier9316673grottier
grouper104210093grouper
grouser84513693grouser
grouter84412523grouter
groutier9297173groutier
grower104614933gro_wer
growler11318973growler
growthier1642203growthier
heather133914853heather
hither124417253_hither
hooter94123933hoot_er
hootier104915353hootier
hotter94720083_hotter
irater65218353irat_er
ironer64216453iro_ner
isothere1145793isothere
isotherm1344283isotherm
ither84617603__ither
josher164312963_josher
jotter134315633_jotter
knotter11317643knotter
kosher134412973_kosher
krater104014313krat_er
kroner104612573kro_ner
lather95124363_lather
leather103815783leather
lither94520953_lither
loather103711003loather
looter64222323loot_er
lotter64025603_lotter
mither114218563_mither
moocher143610673moocher
mooter83921093moot_er
mosher114719793_mosher
mothers123717623_mothers
mothery153710513_mothery
mothier121910213_mothier
mouther123812813mouther
murther1237953murther
neither1037573neither
nether94014163_nether
northern1145583northern
northers1139333northers
nosher94616363_nosher
notcher123610933_notcher
noter55025643_not_er
ocher104516103__ocher
others93918003__others
otter54423973__otter
panther12611443panther
plotter94113663plotter
porter84224413port_er
posher115018163_posher
potherb14358683_potherb
pothers123818623_pothers
potter83926983_potter
potzer174411213_potzer
prater84825353prat_er
prithee1239933prithee
prober104516073pro_ber
prodder1147953prodder
proffer15126933proffer
progger11319373progger
proofer12149103proofer
proper104319953pro_per
prophet14316033prophet
proser84223463pro_ser
prosier93817493prosier
prosper114012193prosper
protea82214763prot_ea
protei82615313prot_ei
prouder10310383prouder
prover113819723pro_ver
prower114218123pro_wer
prowler123310013prowler
prythee1545383prythee
quoter153510093quot_er
rasher95024123_rasher
rater54943283_rat_er
rathe85821923_rathe_
ratter64326313_ratter
richer114015043_richer
rioter64817283riot_er
ritter63822423_ritter
roamer84715163_roamer
roarer63914333_roarer
robber103916533_robber
rochet115423003_rochet
rocker124319573_rocker
roger64521413_ro_ger
rolfer94412273_rolfer
roller63919793_roller
romper104213683_romper
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
rootier74915393rootier
roper75431913_ro_per
ropier84118813_ropier
rosier64221273_rosier
roster64329083_roster
rotche114311983_rotche_
rotches123515703_rotches
rote46249023_rot_e_
rotes56143903_rot_es
rotifer1036993_rotifer
rotor55519733_rot_or
rotte54625933_rotte_
rotted74524433_rotted
rotten64115433_rotten
rotters74421393_rotters
rottes64524833_rottes
rougher113511033_rougher
rouser65224083_rouser
router65025843_router
rover85527373_ro_ver
rower85430493_ro_wer
rozzer1437353_rozzer
rusher94019653_rusher
scoter83815483scot_er
scouther1356943scouther
slather103816083slather
slither104112983slither
slotter73314453slotter
smoother13196673smoother
smothers13349933smothers
smothery16296063smothery
soothe94214853soothe_
soothed113712743soothed
soothers113913433soothers
soothes103917113soothes
sootier73916613sootier
sorter64425093sort_er
souther104116303souther
spotter94514883spotter
swather134213603swather
swither133710993swither
swotter10399473swotter
teether10349693teether
tether93716103_tether
thither13328103thither
tither94920283_tither
tocher114014913_tocher
tooter64420803toot_er
toothed113310243toothed
toothier1136423toothier
tootler73511123tootler
toter55932133_tot_er
totter65021463_totter
trasher104416133trasher
triter65120593trit_er
trochar1257073trochar
troche113112513troche_
trochee122613883trochee
troches123715343troches
troffer13125863troffer
troller73913173troller
trooper94210363trooper
troth85622203troth__
troths95414153troth_s
trotted83711283trotted
trotters83310253trotters
trouper93811433trouper
trouser73812473trouser
troutier8277153troutier
trover95014663tro_ver
ureter6313203uret_er
voter85121053_vot_er
weather133513223weather
wether123315393_wether
whether16346623whether
whither163510253whither
wither124321353_wither
worthed1437873worthed
worthier1436713worthier
wrathed14298523wrathed
wrathier1435903wrathier
wreather14268603wreather
writer94416513writ_er
writhe125310703writhe_
writhed14389623writhed
writhen13407863writhen
writhers14398983writhers
writhes134811703writhes
wronger11288823wronger
wrote84717483wrot_e_
wroth116815883wroth__
wuther124511613_wuther
zither183813083_zither
zootier163611173zootier

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 Filter1786911340270.393454684.5
2DLD Change Limit1340274556.67020094.0
3Display Results4554550.1562916.7
 (SQL Overall)1786914557.21924752.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.