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

337 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
droppers1331859(None) 
croppers143311481croppers
drippers13327931drippers
dropper12329871dropper_
boppers133911922_boppers
choppers174110452choppers
coppers133519752_coppers
crappers144011022crappers
cropper133312962cropper_
cruppers14317312cruppers
diopters1137682diopters
dippers123615172d_ippers
dopers95522482d_o_pers
dorpers104113162d_orpers
drapers105313352dr_apers
dripper12349222dripper_
droners84114382dro_ners
droplets1136062droplets
dropped13329282droppe_d
drovers115212642dro_vers
drowners12428272drowners
floppers15337462floppers
grippers13358122grippers
gropers104813852gro_pers
groupers11358632groupers
hoppers143115142_hoppers
loppers113014102_loppers
moppers133412452_moppers
poppers103414862_poppers
propers113619032pro_pers
prospers123012252prospers
rappers113618442_rappers
rippers114115022_rippers
rompers113412242_rompers
ropers84325902_ro_pers
shoppers153010752shoppers
stoppers123910572stoppers
stroppers1356702stroppers
toppers113914602_toppers
trappers123711022trappers
trippers123210152trippers
troopers10289422troopers
troupers10359422troupers
whoppers18297532whoppers
wrappers15306932wrappers
adopters1136683adopters
arousers84810973arousers
beboppers1742323beboppers
bloopers12397373bloopers
bopper123813833_bopper_
broiders114211183broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610233brooders
brothers133410823brothers
browsers13449193browsers
cappers134419403_cappers
cartoppers1643733cartoppers
chippers173510873chippers
chompers17369573chompers
chopper163611893chopper_
clappers143310833clappers
clippers14368833clippers
coopers114019483_coopers
copers104629843_co_pers
copiers114215963_copiers
copper124321893_copper_
copperas14308563_copperas
coppery16409393_coppery
copters113621273_copters
crapper133913193crapper_
creepers12318623creepers
crimpers14318933crimpers
cripplers15314993cripplers
crispers12309433crispers
croakers14288503croakers
crofters13358893crofters
crooners103911393crooners
cropless1237793cropless
cropped143812063croppe_d
croppies143111133croppies
crosiers103312053crosiers
crossers103912693crossers
croupes114613103croupe_s
croupiers1334633croupiers
crowders14398793crowders
crowers124614893cro_wers
crowners133710743crowners
crozers184111083cro_zers
croziers19287003croziers
crupper13338563crupper_
cuppers133712193_cuppers
dampers123915693d_ampers
dapper114016633d_apper_
deposers11359243deposers
diapers104713893d_iapers
didappers1543163didappers
diopter1038473diopter_
dioptres1146113dioptres
dipper114017783d_ipper_
dobbers123513243d_obbers
dockers143715003d_ockers
dodders105511793d_odders
dodgers105213823d_odgers
doers65225713d_o__ers
doffers14359853d_offers
doggers104413433d_oggers
doodlers10338843doodlers
doozers17419293d_oozers
doper86128393d_o_per_
dopes84935043d_o_pe_s
dopier93515923d_opier_
dormers104313913d_ormers
dorper94314563d_orper_
dorsers83516293d_orsers
dosers75723633d_o_sers
dossers84516233d_ossers
doters74423913d_o_ters
dotters83715973d_otters
dousers84817273d_ousers
dowers104523293d_o_wers
downers113912773d_owners
dowsers115013523d_owsers
dozers164815423d_o_zers
drafters12338523drafters
draggers11357383draggers
drainers92811253drainers
draper94315693dr_aper_
drapery13387943dr_apery
drapes95419653dr_ape_s
drawers113610073dr_awers
drawlers12307313drawlers
dreamers11369003dreamers
dredgers11256093dredgers
dressers9359863dressers
driers74516733dr__iers
drifters12417913drifters
drillers9429713drillers
drinkers13277823drinkers
dripless1135243dripless
dripped13408083drippe_d
drippier1385043drippier_
drivers114412793dr_ivers
drogues9398393drogue_s
droller84110283droller_
drollery12314793drollery
droner74717673dro_ner_
drones75023433dro_ne_s
drooped11368433droope_d
droopier1145573droopier_
droops95110963droop__s
drophead1544613drophead
dropheads1643873dropheads
droplet10312113drople_t
dropouts1144993dropouts
dropperful1851233dropperful
dropperfuls195883dropperfuls
droppersful196813droppersful
dropping14309283dropping
droppings15264503droppings
drops85719503dro_p__s
dropsies1138693dropsies
dropwort1446273dropwort
dropworts1543843dropworts
drosera836203dro_sera
droseras935873dro_seras
drosses84513823drosse_s
drover104614593dro_ver_
droves105116673dro_ve_s
drowner11369803drowner_
drowses114610233drowse_s
drubbers13386023drubbers
drudgers11326843drudgers
drummers13316163drummers
drupes94912653dr_upe_s
druthers1275793druthers
dryers10449273dr__yers
dumpers123412663d_umpers
dupers94615603d__upers
elopers95112943elo_pers
eyedroppers1961613eyedroppers
flappers15388383flappers
flippers15337993flippers
flopper14328473flopper_
foppery17385623_foppery
frappes14328383frappe_s
frippery1832953frippery
frothers14279803frothers
frowners14377933frowners
gippers123212073_gippers
gophers1338983_gophers
grapplers14274303grapplers
graspers11338393graspers
gripers104011463gr_ipers
gripper124410713gripper_
grippes124810373grippe_s
groaners9248493groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
groper94517253gro_per_
gropes95220403gro_pe_s
grossers94410973grossers
grouper104210093grouper_
grousers93810723grousers
grouters95910063grouters
growers113612723gro_wers
growlers12327093growlers
gyppers15235503_gyppers
hoopers123616483_hoopers
hopers114222973_ho_pers
hopper134218483_hopper_
ironers74813543iro_ners
kippers153211423_kippers
knappers16315643knappers
lappers113717463_lappers
lippers113416433_lippers
loopers93914033_loopers
lopers84424143_lo_pers
lopper103717203_lopper_
mappers133313773_mappers
mopers104220373_mo_pers
mopper126215003_mopper_
moppets13307163_moppets
nappers114214863_nappers
nippers113012613_nippers
peoplers1237153peoplers
peppers103311443_peppers
popper93615963_popper_
poppets10338853_poppets
probers113514573pro_bers
prodders1237453prodders
proffers16126593proffers
proggers12258163proggers
prompters1537533prompters
proofers13118363proofers
propels113412843pro_pels
proper104319953pro_per_
prophets1539503prophets
propjets1935493propjets
proposers13228523proposers
propped113311953proppe_d
prosers94219643pro_sers
prosper114012183prosper_
provers123817793pro_vers
prowlers13328933prowlers
quippers2184803quippers
rapers84327183_r_apers
rapiers95012873_rapiers
rappees113611453_rappees
rappels11448803_rappels
rapper104621573_rapper_
raspers94415913_raspers
reapers93520453_reapers
repapers1258833_repapers
ripper103518653_ripper_
ripplers12337113_ripplers
roamers93713453_roamers
roarers73812733_roarers
robbers112814153_robbers
rockers133916553_rockers
rogers74517913_ro_gers
rolfers104011813_rolfers
rollers73117473_rollers
romper104213683_romper_
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
roper75431913_ro_per_
ropery114313873_ro_pery
ropes75940063_ro_pe_s
ropier84118803_ropier_
rosters73727533_rosters
rotters74421393_rotters
rousers75220133_rousers
routers74822853_routers
rovers95423523_ro_vers
rowers94924573_ro_wers
rozzers1535633_rozzers
sappers113518893_sappers
scoopers124210193scoopers
scrappers1545843scrappers
scuppers1446533scuppers
shippers153012303shippers
shopper143312623shopper_
shoppes143411383shoppe_s
sippers113117743_sippers
skippers16318193skippers
slappers123710933slappers
slippers123711223slippers
slopers94213093slo_pers
snappers123510163snappers
snippers12299713snippers
snoopers10319833snoopers
soapers93715923_soapers
steppers12289273steppers
stompers123610033stompers
stoopers103711293stoopers
stopers94217363sto_pers
stopper113012593stopper_
strappers1346733strappers
strippers1355753strippers
stropper1247753stropper_
suppers113314693_suppers
swappers15358073swappers
swoopers13317523swoopers
tappers113416543_tappers
tippers113414343_tippers
topers85025323_to_pers
topper103817603_topper_
trampers123210373trampers
trapper113912793trapper_
tripper113711923tripper_
trippets12357423trippets
troffers14125423troffers
trollers83211203trollers
trompes114111623trompe_s
trooper94210353trooper_
tropes84824353tro_pe_s
trotters83310233trotters
trouper93811413trouper_
troupes94112843troupe_s
trousers83910623trousers
trovers103713313tro_vers
trowsers11427983trowsers
uppers102912283__uppers
whappers18276743whappers
whippers18329033whippers
whoopers16286263whoopers
whopper17328503whopper_
wrapper14368333wrapper_
wrongers12327773wrongers
yappers144012253_yappers
zappers203911633_zappers
zippers203310373_zippers

Search took 9 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.1531167915.0
2DLD Change Limit1461623378.17317883.5
3Display Results3373370.1402407.1
 (SQL Overall)1786913378.46621106.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.