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

437 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
dropped1332928(None) 
cropped143812061cropped
dripped13408081dripped
drooped11368431drooped
dropper12329871dropper
propped113311951propped
bopped134413402_bopped
chopped174511002chopped
clopped143611522clopped
copped135221252_copped
crapped143912622crapped
cropper133312962cropper
dapped124516762d_apped
dipped123517492d_ipped
doped95326712d_o_ped
draped105314362dr_aped
dripper12349232dripper
drolled93810222drolled
droned84616862dro_ned
drooled9369202drooled
drophead1544612drophead
droplet10312112droplet
droppers13318602droppers
dropsied1234962dropsied
drouked1335542drouked
droved114611642dro_ved
drowned12419902drowned
drowsed12448742drowsed
dupped124411642d_upped
flopped15338762flopped
fopped144012672_fopped
frapped15318852frapped
glopped13347612glopped
gripped13419342gripped
groped107515052gro_ped
grouped11419192grouped
hopped144318112_hopped
knopped16355442knopped
lopped114218622_lopped
mopped134114322_mopped
plopped11288772plopped
popped104117812_popped
prepped11329892prepped
rapped114122682_rapped
repped114616722_repped
ripped114419012_ripped
romped114513652_romped
roped84630802_ro_ped
rouped95717352_rouped
shopped153512212shopped
slopped123511442slopped
sopped114819902_sopped
stopped124512202stopped
stropped1367342stropped
swopped15437672swopped
topped114617722_topped
trapped124512212trapped
tripped123911692tripped
tromped124210292tromped
trooped104010722trooped
trouped103910982trouped
whopped18358002whopped
wrapped15338022wrapped
adopted1136253adopted
airdropped1651853airdropped
aroused84914343aroused
barhopped1942183barhopped
blipped14377193blipped
blooped12398543blooped
bopper123813833_bopper
broiled103811423broiled
bronzed19308213bronzed
brooded113510933brooded
brooked143610033brooked
broomed124111053broomed
browed125216393bro_wed
browned134710973browned
browsed134511233browsed
capped134721853_capped
carhopped1972763carhopped
chapped172711443chapped
chipped174110813chipped
chomped17329773chomped
chopper163611893chopper
clapped143511173clapped
clipped14439833clipped
clomped14398973clomped
comped135919873_comped
cooped114821603_cooped
coopted123710763coopted
coped105036843_co_ped
copied114618563_copied
copper124321893_copper
couped115019313_couped
cramped144712183cramped
craped116120523cr_aped
crapper133913193crapper
creeped12329713creeped
creped114115703cr_eped
crimped143910763crimped
crippled15336793crippled
crisped124010103crisped
croaked143710533croaked
crocked164014433crocked
crooked143910943crooked
crooned103813343crooned
croppers143311483croppers
croppie13278793croppie
croppies143111133croppies
crossed105313893crossed
croupe105114433croupe_
croupes114613103croupes
crowded14418783crowded
crowed124717293cro_wed
crowned133912423crowned
crumped144311223crumped
crupper13338563crupper
cupped134413983_cupped
damped124315583d_amped
dapper114016633d_apper
dappled1336393dappled
deponed113712873deponed
deposed113412023deposed
dimpled132810303dimpled
diopter1038473diopter
dipper114017793d_ipper
doated84118183d_oated
docked145018333d_ocked
dodged107514683d_odged
doffed14428503d_offed
dogged106017703d_ogged
doiled84817293d_oiled
doited85016633d_oited
doled75430913d_o_led
dolled83518073d_olled
domed95423263d_o_med
donned85015743d_onned
doodled10369463doodled
doomed104113293d_oomed
dope76038893d_o_pe_
doper86128393d_o_per
dopes84935043d_o_pes
dopey116020353d_o_pey
dopier93515923d_opier
dorper94314573d_orper
dosed76626913d_o_sed
dossed84516633d_ossed
doted75227073d_o_ted
dotted84717523d_otted
doused84821163d_oused
dowed104632613d_o_wed
downed115314783d_owned
dowsed115015013d_owsed
dozed165619353d_o_zed
drabbed13428723drabbed
drafted12439033drafted
dragged11379563dragged
drained93713253drained
drammed13378073drammed
drape85319633dr_ape_
draper94315693dr_aper
drapes95419653dr_apes
drapey125010583dr_apey
dratted9358593dratted
drawled12368343drawled
drayed115911393dr_ayed
dreaded103612023dreaded
dreamed114310633dreamed
dredged11346883dredged
dreed75222843dr__eed
dressed93511873dressed
dribbed13326753dribbed
dried75321383dr__ied
drifted12367953drifted
drilled94711673drilled
drippers13327943drippers
drippier1385043drippier
drippy14445653dripp_y
drogue8938333drogue_
drogues9398393drogues
droid74218543dro__id
droller84110283droller
dromond1135473dromond
drone65324983dro_ne_
droner74717673dro_ner
drones75023433dro_nes
droop85814823droop__
droopier1145573droopier
droops95110963droop_s
droopy12458243droop_y
drop75324403dro_p__
dropheads1643873dropheads
droplets1136063droplets
dropout10410003dropout
dropping14309283dropping
drops85719503dro_p_s
dropsies1138693dropsies
dropsy12497473dro_psy
dropt86924433dro_p_t
drosses84513823drosses
drove95518063dro_ve_
drover104614593dro_ver
droves105116673dro_ves
drownd11478313dro_wnd
drownded14334433drownded
drowner11369803drowner
drowse105010553drowse_
drowses114610233drowses
drubbed13406983drubbed
drudged11277613drudged
drugged11367183drugged
drummed13306323drummed
drupe85012993dr_upe_
drupes94912653dr_upes
dumped123814493d_umped
duped95118323d__uped
eloped95914143elo_ped
eroded84313583ero_ded
erupted10207163erupted
estopped1334993estopped
flapped15328253flapped
flipped15358513flipped
flopper14328473flopper
frappe13286953frappe_
frappes14328383frappes
frocked17439333frocked
frogged13408493frogged
fronded12388863fronded
fronted114011273fronted
frosted113211873frosted
frothed14288783frothed
frowned14348833frowned
gapped124217123_gapped
gipped124815903_gipped
graphed1498473graphed
grappled14336093grappled
grasped11409063grasped
griped104114713gr_iped
grippe115310323grippe_
gripper124410713gripper
grippes124810373grippes
groaned9259973groaned
groined92710813groined
grokked1233673grokked
groomed11379503groomed
grooved12347253grooved
grope84821613gro_pe_
groper94517253gro_per
gropes95220403gro_pes
grossed93812253grossed
grouper104210093grouper
groused94712833groused
grouted94111503grouted
groved114413703gro_ved
growled12278163growled
grumped13337333grumped
gypped15377113_gypped
happed144820103_happed
hipped144317693_hipped
hooped125518183_hooped
hoped115628183_ho_ped
hopper134218483_hopper
hoppled15338083_hoppled
ironed74916013iro_ned
kepped15309533_kepped
kipped153114573_kipped
knapped16397103knapped
lapped114320033_lapped
lipped114419543_lipped
looped95217173_looped
loped85128333_lo_ped
lopper103717203_lopper
louped95316383_louped
mapped134015883_mapped
moped105424733_mo_ped
mopper126215003_mopper
moppet126915093_moppet
morphed1537133morphed
napped114218163_napped
nipped113615853_nipped
oped76230153__o_ped
opted84914273__opted
outdropped1643053outdropped
peopled1238493peopled
pepped103113393_pepped
pipped104516543_pipped
pooped113915943_pooped
popper93615963_popper
poppet92717323_poppet
poppied11388983_poppied
poppled11339233_poppled
primped14479153primped
probed114114823pro_bed
proceed12310543proceed
prodded1257733prodded
progged12409803progged
promoed12310083promoed
prompted1536903prompted
pronged113912393pronged
proofed13138723proofed
propel103714063pro_pel
propend123311273propend
proper104319953pro_per
prophet14316033prophet
propined133111503propined
propjet1839913propjet
propmen1338763propmen
proponed132412033proponed
proposed132011073proposed
prosed94921093pro_sed
prosper114012193prosper
proved125016033pro_ved
prowled13309903prowled
pupped105013273_pupped
quipped2175163quipped
ramped114617903_ramped
raped85334623_r_aped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rapper104621573_rapper
rasped94715203_rasped
reaped94122453_reaped
repled93319773_repled
riped85226433_r_iped
ripper103518653_ripper
rippled123110273_rippled
roamed95215093_roamed
roared75015393_roared
robbed113415193_robbed
robed85323733_ro_bed
rocked135022323_rocked
rodded93713703_rodded
rogued84711473_rogued
roiled74320053_roiled
rolfed104510523_rolfed
rolled74220243_rolled
romper104213683_romper
roofed105214743_roofed
rooked114918143_rooked
roomed95218543_roomed
roosed75621593_roosed
rooted75424003_rooted
rope65542913_ro_pe_
roper75431913_ro_per
ropes75940063_ro_pes
ropey106021873_ro_pey
ropier84118803_ropier
rosed65930343_ro_sed
rotted74524433_rotted
rouged86717323_rouged
roupet84218343_roupet
roused75426443_roused
routed75624333_routed
roved95323553_ro_ved
rowed94034323_ro_wed
sapped114422013_sapped
scooped124611743scooped
scoped115116653sco_ped
scrapped1556533scrapped
scrooped1356403scrooped
shipped153312103shipped
shoppe133110323shoppe_
shopper143312633shopper
shoppes143411393shoppes
sipped113720633_sipped
skipped16358413skipped
slapped123511843slapped
slipped124711743slipped
sloped94216853slo_ped
snapped124611203snapped
snipped123510043snipped
snooped103711813snooped
soaped95817973_soaped
souped95017673_souped
stepped123210053stepped
stomped124110533stomped
stooped103813833stooped
stoped94721013sto_ped
stopper113012603stopper
stoppled1345003stoppled
strapped1357823strapped
stripped1357093stripped
stropper1247763stropper
supped114415703_supped
swapped15429143swapped
swooped13418753swooped
tapped113820053_tapped
tipped114418263_tipped
toped85631313_to_ped
topper103817603_topper
toppled12348843_toppled
tramped124312433tramped
trapper113912803trapper
tripled104113833tripled
tripper113711923tripper
trippet113714113trippet
troaked12438253troaked
trocked144312243trocked
troked114114583tro_ked
trolled84312263trolled
trompe105611263trompe_
trompes114111623trompes
trooper94210363trooper
trope75725803tro_pe_
tropes84824353tro_pes
trophied1437643trophied
trothed114010973trothed
trotted83711283trotted
troupe84812433troupe_
trouper93811433trouper
troupes94112853troupes
trowed104714653tro_wed
trumped12439713trumped
tupped114013233_tupped
uncropped1644933uncropped
unripped1335763unripped
unroped102812103unro_ped
upped103715163__upped
uppropped1242463uppropped
uropod937263uro_pod
urped84615283ur__ped
vroomed13366433vroomed
wapped144416473_wapped
whapped18367573whapped
whipped18379333whipped
whomped18345473whomped
whooped16326933whooped
whopper17328503whopper
whupped18365413whupped
woopsed1344733woopsed
wrapper14368333wrapper
wronged12397673wronged
yapped144415143_yapped
yipped143613283_yipped
zapped204213523_zapped
zipped203612983_zipped

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.1401276364.3
2DLD Change Limit1340274377.37318178.1
3Display Results4374370.1433055.9
 (SQL Overall)1786914377.65623340.0
 
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.