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

401 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
flopped1533876(None) 
clopped143611521clopped
flapped15328251flapped
flipped15358511flipped
flopper14328471flopper
fopped144012671f_opped
glopped13347611glopped
lopped114218621_lopped
plopped11288771plopped
slopped123511441slopped
blipped14377192blipped
blooped12398542blooped
bopped134413402_bopped
chopped174511002chopped
clapped143511172clapped
clipped14439832clipped
clomped14398972clomped
copped135221252_copped
cropped143812062cropped
dropped13329282dropped
eloped95914142elo_ped
flapper14359202flapper
flipper14389142flipper
floated113312702floated
flocced15365482flocced
flocked174510252flocked
flogged13528802flogged
flooded12307932flooded
floored11268682floored
floppers15337462floppers
floppier1554632floppier
floppies1546812floppies
floppy1654872flopp_y
flossed11388532flossed
floured11289872floured
flouted113210812flouted
flowed133513762flo_wed
flumped15377712flumped
frapped15318852frapped
hopped144318112_hopped
knopped16355442knopped
lapped114320032_lapped
lipped114419542_lipped
looped95217172_looped
loped85128332_lo_ped
lopper103717202_lopper
louped95316382_louped
mopped134114322_mopped
popped104117812_popped
propped113311952propped
shopped153512212shopped
slapped123511842slapped
slipped124711742slipped
sloped94216852slo_ped
sopped114819902_sopped
stopped124512202stopped
swopped15437672swopped
topped114617722_topped
whopped18358002whopped
adopted1136253adopted
aliped95414283al_iped
bleeped12287273bleeped
bloated104513433bloated
blobbed11366563blobbed
blocked16449983blocked
blooded11379803blooded
bloomed12439433bloomed
blooper11358533blooper
blotted103911833blotted
bloused104310643bloused
blowed125016693blo_wed
blowsed13449023blowsed
blowzed22435973blowzed
bopper123813833_bopper
capped134721853_capped
chapped172711443chapped
chipped174110813chipped
chomped17329773chomped
chopper163611893chopper
clamped144012043clamped
clapper134011863clapper
clasped123610443clasped
cleped115114113cl_eped
clipper133710323clipper
cloaked14368543cloaked
clocked164112833clocked
clogged12528653clogged
cloned94518803clo_ned
clonked14429563clonked
closed95317963clo_sed
clothed134010283clothed
clotted104011823clotted
clouded11348833clouded
cloured103111543cloured
clouted104212163clouted
clowned13447723clowned
cloyed125111563clo_yed
clumped143610663clumped
comped135919873_comped
cooped114821603_cooped
coopted123710763coopted
coped105036843_co_ped
copied114618563_copied
copper124321893_copper
couped115019313_couped
crapped143912623crapped
cropper133312963cropper
cupped134413983_cupped
dapped124516763_dapped
dipped123517493_dipped
doped95326713_do_ped
dripped13408083dripped
drooped11368433drooped
dropper12329873dropper
dupped124411643_dupped
elapsed1056103elapsed
eloined8149813eloined
elope75219343elo_pe_
eloper85414153elo_per
elopes85918163elo_pes
estopped1334993estopped
feoffed1332813feoffed
filliped1435223filliped
flacked173711583flacked
flagged13459633flagged
flailed1137303flailed
flaked144715653fl_aked
flamed124618973fl_amed
flammed15377413flammed
flanged123810843flanged
flanked153710643flanked
flappers15388383flappers
flappier1544293flappier
flappy1654483flapp_y
flared105317603fl_ared
flashed144112183flashed
flatbed13397983flatbed
flatted114012943flatted
flawed134712723fl_awed
flayed134414053fl_ayed
flecked17358073flecked
fled85429773fl___ed
fledged13417843fledged
fleeced13358153fleeced
fleered11309503fleered
fleeted113310233fleeted
flensed1136613flensed
fleshed143210263fleshed
flexed17419083fl_exed
fleyed13408813fl_eyed
flicked174610673flicked
flied96519433fl__ied
flinted114411893flinted
flippers15338003flippers
flippest1535173flippest
flippy1654613flipp_y
flirted11428673flirted
flited104616583fl_ited
flitted114011643flitted
floatel10308013floatel
floater104413353floater
floe76129773flo__e_
floes85528143flo__es
flogger12449463flogger
flood95215603flo__od
flooder11258463flooder
flooey123910173flo_oey
flooie93712153flooie_
floorer10248073floorer
flop96925453flo_p__
flopover1642863flopover
floppiest1654773floppiest
floppily1843773floppily
flopping16388773flopping
flops105920143flo_p_s
florae94713883florae_
floret9321123flo_ret
florid10311453flo_rid
flosser10339693flosser
flosses103411973flosses
flounced1433803flounced
flouter104311343flouter
flower124815503flo_wer
flowered1546013flowered
flubbed15306633flubbed
flued95021253fl__ued
fluffed13295903fluffed
fluked145112093fl_uked
flumed124915263fl_umed
flunked15398413flunked
flushed143310973flushed
fluted104917163fl_uted
fluxed17509673fl_uxed
flypaper1842223flypaper
flyted13378773fl_yted
foaled104515963f_oaled
foamed126014403f_oamed
fobbed144112613f_obbed
fogged125518373f_ogged
foiled104618403f_oiled
foined105915013f_oined
folded114212793f_olded
folioed1138033folioed
fonded115717043f_onded
fooled104317823f_ooled
footed104418623f_ooted
footled113610763footled
footpad1343903footpad
foozled20346893foozled
foppery17385623f_oppery
forced126316523f_orced
forded115020393f_orded
forged115519323f_orged
forked145217143f_orked
formed125021173f_ormed
fouled104315973f_ouled
fowled133914093f_owled
foxed165115213f_o_xed
frappe13286953frappe_
frappes14328383frappes
frocked17439333frocked
frogged13408493frogged
fronded12388863fronded
fronted114011273fronted
frosted113211873frosted
frothed14288783frothed
frowned14348833frowned
galoped11138073galo_ped
gapped124217123_gapped
gipped124815903_gipped
gloated93511533gloated
globed104811763glo_bed
glommed13265443glommed
gloomed11337413gloomed
gloppier1354673gloppier
gloppy1454723glopp_y
gloried9169513gloried
glossed94410073glossed
glouted9429713glouted
gloved114811873glo_ved
glowed114913833glo_wed
glozed173711223glo_zed
gripped13419343gripped
groped107515053gro_ped
grouped11419193grouped
gypped15377113_gypped
happed144820103_happed
hipped144317693_hipped
hooped125518183_hooped
hoped115628183_ho_ped
hopper134218483_hopper
hoppled15338083_hoppled
kepped15309533_kepped
kipped153114573_kipped
knapped16397103knapped
lamped114017543_lamped
lapper104319953_lapper
lappet103817723_lappet
lapsed94712583_lapsed
leaped94317773_leaped
limped114817123_limped
lippen103911403_lippen
lipper104219633_lipper
lisped94113423_lisped
loaded84616873_loaded
loafed104011153_loafed
loamed94414613_loamed
loaned73816293_loaned
lobbed113114613_lobbed
lobed86022133_lo_bed
locked134921663_locked
locoed94312193_locoed
lodged913815703_lodged
lofted103811893_lofted
logged96622943_logged
loided83414023_loided
lolled74315823_lolled
longed87121373_longed
looed64626133_lo_oed
looked114717073_looked
loomed94616763_loomed
looper83817113_looper
loosed75520893_loosed
looted74421113_looted
lope65941923_lo_pe_
loper75129233_lo_per
lopes76437343_lo_pes
loppered13326753_loppered
loppers113014103_loppers
loppier11369723_loppier
loppy125911663_lopp_y
lorded84916733_lorded
lotted74222403_lotted
loupe75319513_loupe_
loupen84510293_loupen
loupes84918053_loupes
loured74617403_loured
loused74822913_loused
louted74920693_louted
loved95021363_lo_ved
lowed95233903_lo_wed
loxed135017053_lo_xed
lumped114216963_lumped
mapped134015883_mapped
moped105424733_mo_ped
mopper126215003_mopper
moppet126915093_moppet
napped114218163_napped
nipped113615853_nipped
oped76230153__o_ped
opted84914273__opted
peopled1238493peopled
pepped103113393_pepped
pipped104516543_pipped
plodded1265563plodded
plonked14348103plonked
plotted104612373plotted
plotzed19376223plotzed
plowed124213203plo_wed
ployed124310563plo_yed
plumped14318643plumped
polyped1537173polyped
pooped113915943_pooped
popper93615963_popper
poppet92717323_poppet
poppied11388983_poppied
poppled11339233_poppled
prepped11329893prepped
pupped105013273_pupped
quipped2175163quipped
rapped114122683_rapped
repped114616723_repped
ripped114419013_ripped
romped114513653_romped
roped84630803_ro_ped
rouped95717353_rouped
sapped114422013_sapped
scooped124611743scooped
scoped115116653sco_ped
shipped153312103shipped
shlepped1633643shlepped
shoppe133110323shoppe_
shopper143312633shopper
shoppes143411393shoppes
sipped113720633_sipped
skipped16358413skipped
slapper113512463slapper
sliped95417063sl_iped
slipper113712983slipper
slogged104910473slogged
slope75823563slo_pe_
sloper84615913slo_per
slopes84820453slo_pes
sloppier1255703sloppier
sloppy1395303slopp_y
sloshed11329823sloshed
slotted84613883slotted
slowed104617073slo_wed
slumped123710153slumped
slurped10368753slurped
snapped124611203snapped
snipped123510043snipped
snooped103711813snooped
soaped95817973_soaped
souped95017673_souped
stepped123210053stepped
stomped124110533stomped
stooped103813833stooped
stoped94721013sto_ped
stopper113012603stopper
stoppled1345003stoppled
stropped1367343stropped
supped114415703_supped
swapped15429143swapped
swooped13418753swooped
tapped113820053_tapped
tipped114418263_tipped
toped85631313_to_ped
topper103817603_topper
toppled12348843_toppled
trapped124512213trapped
tripped123911693tripped
tromped124210293tromped
trooped104010723trooped
trouped103910983trouped
tupped114013233_tupped
unflapped1743093unflapped
upped103715163__upped
wapped144416473_wapped
whapped18367573whapped
whipped18379333whipped
whomped18345473whomped
whooped16326933whooped
whopper17328503whopper
whupped18365413whupped
woopsed1344733woopsed
wrapped15338023wrapped
yapped144415143_yapped
yipped143613283_yipped
zapped204213523_zapped
zipped203612983_zipped

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274016.42320866.7
3Display Results4014010.1402864.3
 (SQL Overall)1786914016.70326658.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.