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

410 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
blooper1135853(None) 
bloomer11419811bloomer
blooped12398541blooped
bloopers12397371bloopers
looper83817111_looper
bleeper11458252bleeper
bloater94013422bloater
blocker15419922blocker
blogger11448312blogger
blonder104011942blonder
blooded11379802blooded
bloodier1136822bloodier
blooey115110792bloo_ey
blooie83913192blooie_
bloomed12439432bloomed
bloomers12348822bloomers
bloomery15335692bloomery
bloomier1275782bloomier
bloop96116152bloop__
bloops106611342bloop_s
blotter94612852blotter
blower115316572bl_ower
blowier1248942blowier
booger94816552b_ooger
booker124719192b_ooker
boomer104618512b_oomer
boozer174815962b_oozer
bopper123813832b_opper
brooder103811622brooder
cooper104221122_cooper
eloper85414152el_oper
flooder11258462flooder
floorer10248072floorer
flopper14328472flopper
hooper114518312_hooper
looker104816952_looker
looped95217172_looped
loopers93914032_loopers
loopier93711192_loopier
looser65219942_looser
looter64222322_looter
loper75129232_l_oper
lopper103717202_lopper
scooper113812032scooper
sloper84615912sl_oper
snooper93511532snooper
stooper93813192stooper
swooper12389172swooper
trooper94210362trooper
whooper15297152whooper
allover1038583allover
almoner949383almoner
balloter1078893balloter
bebopper1642103bebopper
beeper103714093b_eeper
bellower13159063bellower
biotope1146623biotope_
biotopes1246963biotopes
blabber10418923blabber
blacker154513513blacker
bladder11429153bladder
blader93618583bl_ader
blamer104417143bl_amer
blander103715163blander
blanker134612023blanker
blaster94017303blaster
blather125314203blather
blatter94415653blatter
blazer174414023bl_azer
blazoner1944133blazoner
bleaker133510533bleaker
bleater94515303bleater
bleeder10359643bleeder
bleeped12287273bleeped
bleepers12377493bleepers
blender104613843blender
blesser9329293blesser
blether12459913blether
blinder103912983blinder
blinker134110213blinker
blipped14377193blipped
blister94415313blister
blither124812173blither
blitzer18447663blitzer
bloated104513433bloated
bloaters103311023bloaters
blobbed11366563blobbed
blocked16449983blocked
blockers16398793blockers
blockier1666133blockier
bloggers12397403bloggers
bloke114316633bl_oke_
blokes123813883bl_okes
blonde94813293blonde_
blondes104213163blondes
blood85319523bloo__d
bloodied1245973bloodied
bloodies11310163bloodies
bloodred1234083bloodred
bloods94614843bloo_ds
bloody124710173bloo_dy
bloom95918973bloo__m
blooms104613173bloo_ms
bloomy134510113bloo_my
blooping13248843blooping
blotted103911833blotted
blotters104110983blotters
blottier10336413blottier
blouse84714723blouse_
bloused104310643bloused
blouses94014463blouses
blousier1055663blousier
blowed125016693bl_owed
blowers124313593bl_owers
blowsed13449023blowsed
blowsier1335063blowsier
blowzed22435973blowzed
blowzier2233413blowzier
blubber10399293blubber
blucher143310223blucher
bludger11419563bludger
bluer74918493bl__uer
bluffer15396883bluffer
blunder103813153blunder
blunger104112013blunger
blunter94512033blunter
blurter9419833blurter
blusher124113113blusher
bluster94215313bluster
blype12429673bl_ype_
blypes13357543bl_ypes
boater84622093b_oater
bobber95016743b_obber
boiler84319273b_oiler
bolder94820933b_older
boloney1247763boloney
bolster93713423bolster
bolter83920753b_olter
bomber125014653b_omber
bonder95324783b_onder
boner75133083b__oner
bonier84321993b_onier
bonzer175313673b_onzer
boobed114514873b_oobed
boodler103312003boodler
booed85127273b_oo_ed
boogers104514633b_oogers
boogey124711523b_oogey
booked135319503b_ooked
bookers134016613b_ookers
boomed115318133b_oomed
boomers114115913b_oomers
boomier113312183boomier
boor66130683b_oo__r
booster94314553booster
booted94822733b_ooted
bootee84323023b_ootee
bootery1238983b_ootery
booze164718913b_ooze_
boozed184813833b_oozed
boozers183912443b_oozers
boozes174916523b_oozes
boozier18349013boozier
bopped134413403b_opped
boppers133911923b_oppers
border94419973b_order
borer75131273b__orer
bosker123813653b_osker
bother115218063b_other
bower107328183b__ower
bowler114217313b_owler
bowyer14368923b_owyer
boxer145016523b__oxer
boxier154311743b_oxier
broader103412613broader
broider103912973broider
broiler92911753broiler
broker124314243b_roker
bronzer18348493bronzer
brooded113510933brooded
brooders112610243brooders
broodier1157433broodier
brooked143610033brooked
broomed124111053broomed
broomier1236873broomier
brother123311333brother
browner124911643browner
browser124911143browser
bumper123714343b_umper
buxomer1833243buxomer
chomper163810073chomper
chooser124412973chooser
chopper163611893chopper
clamper134012993clamper
clapper134011863clapper
clasper113811863clasper
clipper133710323clipper
clobber13378163clobber
clocker153910873clocker
clogger11438803clogger
clomped14398973clomped
cloner84418093cl_oner
clopped143611523clopped
closer84918203cl_oser
clouter93511693clouter
clover114617123cl_over
clowder13367943clowder
colorer9312523colorer
cooer74831013_coo_er
cooker124722453_cooker
cooler84824713_cooler
cooped114821603_cooped
coopers114019483_coopers
coopery143910273_coopery
cooter85128613_cooter
coper95336093__coper
copper124321893_copper
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
doozer163910463_doozer
doper86128393__doper
dorper94314573_dorper
drooped11368433drooped
droopier1145573droopier
dropper12329873dropper
eloiner7149183eloiner
elope75219343el_ope_
eloped95914143el_oped
elopers95112943el_opers
elopes85918163el_opes
flapper14359203flapper
flipper14389143flipper
floater104413353floater
flogger12449463flogger
flooded12307933flooded
flooders12257833flooders
flooey123910173floo_ey
flooie93712153flooie_
floor84215233floo__r
floored11268683floored
floorers11227573floorers
flopover1642863flopover
flopped15338763flopped
floppers15337463floppers
floppier1554633floppier
flosser10339693flosser
flouter104311343flouter
flower124815503fl_ower
flyover1633513flyover
footer94320773_footer
galloper11137183galloper
gloater83711013gloater
gloomed11337413gloomed
gloomier1135093gloomier
glopped13347613glopped
gloppier1354673gloppier
glosser83410813glosser
glover104513533gl_over
glower105114933gl_ower
goober93911743_goober
gooier73516213_gooier
goopier103910573_goopier
groomer10399873groomer
groover11358543groover
groper94517253_groper
grouper104210093grouper
hoofer124014953_hoofer
hooker134820173_hooker
hooped125518183_hooped
hoopers123616483_hoopers
hooter94123933_hooter
hoover124314433_hoover
hoper105829143__hoper
hopper134218483_hopper
lapper104319953_lapper
leaper88118943_leaper
leper74820743_l_eper
limper104117853_limper
lipper104219633_lipper
lisper84114433_lisper
loader74316313_loader
loafer93610943_loafer
loaner64416503_loaner
lobber104016603_lobber
locker124019423_locker
lodger86517693_lodger
lofter94614723_lofter
logger86420003_logger
logier75015733_logier
loiter64619173_loiter
loller63315283_loller
loner55431043_l_oner
longer75823203_longer
looed64626133_loo_ed
looey84822913_loo_ey
looie55624243_looie_
looies65025833_looies
looked114717073_looked
lookers114014073_lookers
loomed94616763_loomed
looney94712413_looney
loonier73312683_loonier
loop67835013_loop__
loops75723963_loop_s
loopy105316643_loop_y
loose56627683_loose_
loosed75520893_loosed
loosen66615963_loosen
looses67328243_looses
looted74421113_looted
looters74419163_looters
lope65941923_l_ope_
loped85128333_l_oped
lopers84424143_l_opers
lopes76437343_l_opes
lopped114218623_lopped
loppers113014103_loppers
loppier11369723_loppier
loser54728673_l_oser
lotter64025603_lotter
louder74414603_louder
loupe75319513_loupe_
louped95316383_louped
loupen84510293_loupen
loupes84918053_loupes
louver94110393_louver
lover85526453_l_over
lower85830413_l_ower
lumper103816653_lumper
mooner85317833_mooner
mooter83921093_mooter
moper94925923__moper
mopper126215003_mopper
nooser65517823_nooser
onlooker1243473onlooker
plodder1146003plodder
plopped11288773plopped
plotter94113663plotter
plover115312613pl_over
plower114315063pl_ower
plumper13318773plumper
pooler83819843_pooler
pooped113915943_pooped
poorer82613993_poorer
popper93615963_popper
proofer12149103proofer
proper104319953_proper
prosper114012193prosper
romper104213683_romper
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
roper75431913__roper
scooped124611743scooped
scoopers124210193scoopers
scooter93312873scooter
shooter103013993shooter
shopper143312633shopper
slapper113512463slapper
sleeper93211563sleeper
slipper113712983slipper
slobber11388903slobber
slogger94310483slogger
sloop76118913sloop__
sloops85513623sloop_s
slope75823563sl_ope_
sloped94216853sl_oped
slopers94213093sl_opers
slopes84820453sl_opes
slopped123511443slopped
sloppier1255703sloppier
slotter73314453slotter
slower94016153sl_ower
snooker113910303snooker
snooped103711813snooped
snoopers10319843snoopers
snoopier10177273snoopier
snoozer16409193snoozer
soaper84517873_soaper
sooner64220463_sooner
spoofer12368723spoofer
spooler93711383spooler
stomper114111233stomper
stooker113811733stooker
stooped103813833stooped
stoopers103711303stoopers
stoper84320103_stoper
stopper113012603stopper
swooner10358673swooner
swooped13418753swooped
swoopers13317523swoopers
swoopier13175143swoopier
tooler63818613_tooler
tooter64420803_tooter
toper75231023__toper
topper103817603_topper
trooped104010723trooped
troopers10289443troopers
trouper93811433trouper
walloper13147113walloper
whooped16326933whooped
whoopee15287513whoopee
whoopers16286263whoopers
whopper17328503whopper
wooer84316693_woo_er
woofer124411363_woofer
wooler93615873_wooler
zooier153411233_zooier

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.420425454.8
2DLD Change Limit1340274106.69020033.9
3Display Results4104100.1402928.6
 (SQL Overall)1786914107.25024647.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.