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

433 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
frothed1428878(None) 
frother133110151frother
trothed114010971trothed
brothel12318192brothel
brother123311332brother
clothed134010282clothed
crotched16428592crotched
faithed1437162faithed
footed104418622foot_ed
footled113610762footled
freshed143312592freshed
fretted113411852fretted
fritted113611332fritted
frocked17439332frocked
frogged13408492frogged
fronded12388862fronded
fronted114011272fronted
frosted113211872frosted
froth115919282froth__
frothers14279812frothers
frothier1435952frothier
froths125411442froth_s
frothy15578372froth_y
frowned14348832frowned
rotted74524432_rotted
soothed113712742soothed
toothed113310242toothed
trotted83711282trotted
worthed1437872worthed
wrathed14298522wrathed
writhed14389622writhed
airthed11328303airthed
another10289153another
apothem1444643apothem
arched125717323ar_ched
aroused84914343aroused
azoted16388593azot_ed
bathed125518743_bathed
berthed13259123berthed
betrothed1544943betrothed
birthed13228593birthed
blotched1635653blotched
blotted103911833blotted
booted94822733boot_ed
botched153611903_botched
bother115218063_bother
breathed14469643breathed
broached16309123broached
broche133612103broche_
broiled103811423broiled
bronzed19308213bronzed
brooded113510933brooded
brooked143610033brooked
broomed124111053broomed
broth106521093broth__
brothels13277073brothels
brothered1546003brothered
brothers133410833brothers
broths115013923broth_s
brothy14519623broth_y
browed125216393bro_wed
browned134710973browned
browsed134511233browsed
brushed133811213brushed
bruted95113263brut_ed
clothe114712993clothe_
clothes124513813clothes
clotted104011823clotted
coshed124217543_coshed
coted85033853_cot_ed
crashed134214203crashed
crated94827773crat_ed
croaked143710533croaked
crochet143616663crochet
crocked164014433crocked
crooked143910943crooked
crooned103813343crooned
cropped143812063cropped
crossed105313893crossed
crotches153411303crotches
crotchet152711993crotchet
crouched16359143crouched
crowded14418793crowded
crowed124717303cro_wed
crowned133912433crowned
crushed134111963crushed
crutched16307463crutched
doted75227073_dot_ed
dotted84717523_dotted
dratted9358593dratted
drolled93810223drolled
droned84616863dro_ned
drooled9369203drooled
drooped11368433drooped
drophead1544613drophead
dropped13329283dropped
drouked1335543drouked
droved114611643dro_ved
drowned12419903drowned
drowsed12448743drowsed
earthed1139923earthed
emoted94614923emot_ed
eroded84313583ero_ded
erotized1838553erotized
fagoted1236073fagot_ed
farted105121783fart_ed
farther1348343farther
fashed136720253f_ashed
fasted105320953fast_ed
fated95632133f_at_ed
fathead1437863f_athead
father125116713f_ather
fatted105419843f_atted
feather133613503feather
felted103714653felt_ed
feoffed1332813feoffed
fetched163710473fetched
feted94420933f_et_ed
fetted104817893f_etted
fettled11378933fettled
filched16307423filched
fished134316313f_ished
fisted104218703fist_ed
fitted104716663f_itted
flashed144112183flashed
flatbed13397983flatbed
flathead1535803flathead
flatted114012943flatted
fleshed143210263fleshed
fletched17306693fletched
flitched17256293flitched
flited104616583flit_ed
flitted114011643flitted
floated113312703floated
flocced15365483flocced
flocked174510253flocked
flogged13528803flogged
flooded12307933flooded
floored11268683floored
flopped15338763flopped
flossed11388533flossed
floured11289873floured
flouted113210813flouted
flowed133513763flo_wed
flushed143310973flushed
fluted104917163flut_ed
flyted13378773flyt_ed
foaled104515963f_oaled
foamed126014403f_oamed
fobbed144112613f_obbed
fogged125518373f_ogged
foiled104618403f_oiled
foined105915013f_oined
folded114212793f_olded
fonded115717043f_onded
fooled104317823f_ooled
footer94320773foot_er
foothold1545203foothold
footie94718143footie_
footier104115113footier
footies103721543footies
footle93914383footle_
footler104011873footler
footles103715713footles
footmen1246583footmen
footpad1343903footpad
foozled20346893foozled
fopped144012673f_opped
foraged124812283foraged
forayed14368593forayed
forced126316523f_orced
forded115020393f_orded
forehead1537893forehead
forged115519323f_orged
forked145217143f_orked
formed125021173f_ormed
forte86131463fort_e_
fortes95327183fort_es
forth116222673forth__
forties104323863forties
fortuned1285323fortuned
fouled104315973f_ouled
fowled133914103f_owled
foxed165115213f_o_xed
fracted1339373fracted
fragged134010163fragged
framed125116523fr_amed
franked153610053franked
frapped15318853frapped
frater94520593frat_er
frayed135012163fr_ayed
freaked15399703freaked
freed95223543fr__eed
frenched17299433frenched
freshen133010883freshen
fresher132612643fresher
freshes133515823freshes
freshet133416643freshet
fretter103412753fretter
fried95322913fr__ied
frigged13439053frigged
frighted1657173frighted
frilled113911603frilled
fringed123611523fringed
frisked15478823frisked
frites94922483frit_es
frith115922033frith__
friths124313583frith_s
fritter103912773fritter
fritzes19329453fritzes
frized193510683fr_ized
frizzed19375973frizzed
froe75329993fro__e_
froes86126693fro__es
frogeyed1642783frogeyed
froglet11310063froglet
frogmen1335893frogmen
frond95316343fro__nd
fronter103611583fronter
frontes104214163frontes
frontier1147313frontier
frontlet1147653frontlet
frontmen1344423frontmen
frore86218803fro_re_
frosh115713403frosh__
frosteds12305653frosteds
frostier1148163frostier
frothiest1537453frothiest
frothily1745303frothily
frothing15208533frothing
frotteur1142503frotteur
frounced1434493frounced
froward1436673froward
frowner13429683frowner
frowsted1534313frowsted
froze174515653fro_ze_
frozen18408443fro_zen
frugged13387293frugged
fruited11389093fruited
further1337003further
futzed19418983f_utzed
garoted9710133garot_ed
garotted1066193garotted
girthed12266243girthed
graphed1498473graphed
grated84523923grat_ed
gritted94110903gritted
groaned9259973groaned
groined92710813groined
grokked1233673grokked
groomed11379503groomed
grooved12347253grooved
groped107515053gro_ped
grossed93812253grossed
grottoed10234503grottoed
grouched15356663grouched
grouped11419193grouped
groused94712833groused
grouted94111503grouted
groved114413703gro_ved
growled12278173growled
grutched15284673grutched
hooted104422663hoot_ed
hotbed123310683_hotbed
hotched163610923_hotched
hothead14349293_hothead
hotted104319943_hotted
ironed74916013iro_ned
joshed174610903_joshed
jotted143615173_jotted
kithed144613013_kithed
knotted12357233knotted
kythed17407313_kythed
lathed104718453_lathed
loathed11419443loathed
looted74421113loot_ed
lotted74222403_lotted
mooched153910533mooched
mooted94120373moot_ed
morphed1537133morphed
moshed124517493_moshed
mother113718643_mother
mouthed133811043mouthed
norther1039733norther
noshed104413503_noshed
notched134210303_notched
noted65123843_not_ed
nother93815963_nother
ohed87825183__o_hed
oohed94214213__oohed
orated74221503orat_ed
orotund844063orotund
other84219103__other
photoed1338913photoed
pithed124615613_pithed
plotted104612373plotted
plotzed19376223plotzed
pooched152810083pooched
poohed123912523_poohed
ported94223243port_ed
pothead133810393_pothead
pother113818853_pother
potted94624013_potted
prated94924923prat_ed
prithee1239933prithee
probed114114823pro_bed
proceed12310553proceed
prodded1257733prodded
progged12409803progged
promoed12310083promoed
pronged113912393pronged
proofed13138723proofed
prophet14316033prophet
propped113311953propped
prosed94921093pro_sed
protea82214763prot_ea
protei82615313prot_ei
proteid103513673proteid
protend104012793protend
proved125016033pro_ved
prowled13309913prowled
prythee1545383prythee
quoted16359453quot_ed
rated65441383_rat_ed
rathe85821923_rathe_
rather94319743_rather
ratted74923343_ratted
retched133814273_retched
retied75924983_retied
retted74826313_retted
rioted73416373riot_ed
roached133211833_roached
roamed95215093_roamed
roared75015393_roared
robbed113415193_robbed
robed85323733_ro_bed
rochet115423003_rochet
rocked135022323_rocked
rodded93713703_rodded
rogued84711473_rogued
roiled74320053_roiled
rolfed104510523_rolfed
rolled74220243_rolled
romped114513653_romped
roofed105214743_roofed
rooked114918143_rooked
roomed95218543_roomed
roosed75621593_roosed
rooted75424003_rooted
rootled83410533rootled
roped84630803_ro_ped
rosed65930343_ro_sed
rotated82715293_rotated
rotche114311983_rotche_
rotches123515703_rotches
rote46249023_rot_e_
rotes56143903_rot_es
rotte54625933_rotte_
rotten64115433_rotten
rotter64325463_rotter
rottes64524833_rottes
rotund737293_rotund
rouged86717323_rouged
roughed124210943_roughed
rouped95717353_rouped
roused75426443_roused
routed75624333_routed
roved95323553_ro_ved
rowed94034323_ro_wed
ruched124314633_ruched
rushed104419863_rushed
rutted74518403_rutted
scathed134012643scathed
scotched16187933scotched
scythed16385303scythed
seethed113410193seethed
shotted113912403shotted
sloshed11329823sloshed
slotted84613883slotted
smoothed14236473smoothed
smother123510213smother
sooted73922593soot_ed
soothe94214853soothe_
soother104215043soother
soothes103917113soothes
sorted74523713sort_ed
sortied83314103sortied
sotted74121403_sotted
southed114313993southed
spathed134013183spathed
spotted103713143spotted
stotted83511423stotted
swathed144611933swathed
swotted11398713swotted
teethed11318623teethed
tithed104115593_tithed
tooted74620123toot_ed
tootled83511043tootled
torched133511353torched
toted64929483_tot_ed
tother94117143_tother
totted74319953_totted
trashed113514703trashed
troaked12438253troaked
troche113112513troche_
trochee122613883trochee
troches123715343troches
trocked144312243trocked
troked114114583tro_ked
trolled84312263trolled
tromped124210293tromped
trooped104010723trooped
trophied1437643trophied
troth85622203troth__
troths95414153troth_s
trotter73312253trotter
trouped103910983trouped
trowed104714653tro_wed
tythed13457503_tythed
voted93919143_vot_ed
vroomed13366433vroomed
withed134416233_withed
wooshed14167403wooshed
wotted104115713_wotted
wreathed15257463wreathed
wretched17276533wretched
writhe125310703writhe_
writhen13407863writhen
writher134010853writher
writhes134811703writhes
wronged12397673wronged
wrote84717483wrot_e_
wroth116815883wroth__

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.406440125.6
2DLD Change Limit1340274336.47020715.1
3Display Results4334330.1403092.9
 (SQL Overall)1786914337.01625469.1
 
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.