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

477 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
blotters10411098(None) 
blatters104414091blatters
bloaters103311021bloaters
blotter94612851blotter_
lotters73921061_lotters
plotters104011551plotters
slotters84012401slotters
allotters965562allotters
batters94626012b_atters
betters94422092b_etters
bitters94920362b_itters
blasters104116142blasters
blathers134713792blathers
blatter94415652blatter_
bleaters103412322bleaters
blethers13429612blethers
blisters104015082blisters
blithers134711232blithers
blitzers19417152blitzers
bloater94013422bloater_
blockers16398792blockers
bloggers12397402bloggers
bloomers12348822bloomers
bloopers12397372bloopers
blotless10347152blotless
blotted103911832blotte_d
blottier10336412blottier_
blowers124313592blo_wers
blurters10348372blurters
blusters104413892blusters
boaters93419242b_oaters
bolsters103712452bolsters
bolters94017802b_olters
boosters104013442boosters
bothers124317752b_others
bottlers103810012b_ottlers
brothers133410832brothers
butters94521722b_utters
clatters103313912clatters
clouters10399802clouters
clutters103210352clutters
cotters94323442_cotters
dotters83715972_dotters
flatters113814202flatters
flitters114312172flitters
floaters112711512floaters
flouters11419272flouters
flutters114010822flutters
glitters93710542glitters
gloaters9288862gloaters
jotters143413802_jotters
knotters12276152knotters
letters73819852_letters
litters73422572_litters
lofters103912902_lofters
loiters74116612_loiters
looters74419162_looters
lotter64025602_lotter_
lottery10389832_lottery
lottes65322752_lotte_s
otters64021512__otters
platters103415282platters
plotter94113662plotter_
potters94024342_potters
rotters74421392_rotters
slitters84014132slitters
slotter73314452slotter_
spotters104313382spotters
swotters11448482swotters
totters74618732_totters
trotters83310242trotters
abetters1057173abetters
aborters1038573aborters
abutters1056993abutters
adopters1136693adopters
allottees964323allottees
allotter866473allotter_
alters64924223al__ters
baiters94619303b_aiters
balloters1157673balloters
balusters1136643balusters
banters94623113b_anters
barters94223033b_arters
basters94930303b_asters
bathers124720363b_athers
battens95313263b_attens
batter84928873b_atter_
battery124911813b_attery
battlers104110973battlers
beaters94925043b_eaters
beetlers1037393beetlers
begetters12135043begetters
belittlers1242023belittlers
belters93819413b_elters
besetters11136633besetters
betatters1134963betatters
better84723703b_etter_
bettors93312473b_ettors
billeters1136873billeters
biometers1339173biometers
biotites10310083biotite_s
bisters93922613b_isters
biters83925243b__iters
bitter84622673b_itter_
bittern94810683b_ittern
bitterns10428953b_itterns
blabbers11308153blabbers
bladders12397803bladders
bladers104214683bl_aders
blamers115314213bl_amers
blaster94017303blaster_
blather125314203blather_
blatted104812713blatte_d
blattered12198563blattered
blazers184811683bl_azers
bleater94515303bleater_
bleeders11448453bleeders
bleepers12377493bleepers
blenders115210993blenders
blessers10277633blessers
blether12459913blether_
blighters1555743blighters
blinders113911143blinders
blinkers14388503blinkers
blister94415313blister_
blistery13418713blistery
blites84721213bl_ite_s
blither124812173blither_
blitzer18447663blitzer_
blitzes18408703blitze_s
bloated104513433bloate_d
bloats85215763bloat__s
blocker15419923blocker_
blogger11448313blogger_
blokes123813883blo_ke_s
blonder104011943blonder_
blondes104213163blonde_s
bloomer11419813bloomer_
bloomery15335693bloomery
blooper11358533blooper_
blotches1537433blotches
blots75626173blo_t__s
blottiest11286833blottiest
blotting113910433blotting
blotto8198443blott__o
blotty11178343blott__y
blouses94014463blouse_s
blower115316573blo_wer_
blowier1248943blowier_
blubbers11408143blubbers
bluchers15359033bluchers
bludgers12397853bludgers
bluffers16405703bluffers
blunders113911343blunders
blungers11469843blungers
blunter94512033blunter_
blurter9419833blurter_
blushers133911293blushers
bluster94215313bluster_
blustery13368003blustery
boasters103915663boasters
boatels93510233b_oatels
boater84622093b_oater_
bobbers103614283b_obbers
boilers93417063b_oilers
boites84322703b_oite_s
boletes9316063bolete_s
bolometers1447383bolometers
bolster93713423bolster_
bolter83920753b_olter_
boltless10338283boltless
bombers134512593b_ombers
bonders104120663b_onders
boners84825433b_o_ners
bonkers134015303b_onkers
boodlers113710743boodlers
boogers104514633b_oogers
bookers134016613b_ookers
boomers114115913b_oomers
booster94314553booster_
bootees94114473b_ootees
bootery1238983b_ootery
booties94124613bootie_s
bootlegs11325873bootlegs
bootless103410983bootless
boozers183912443b_oozers
boppers133911923b_oppers
borders104317533b_orders
borers85122683b_o_rers
botchers153511543b_otchers
botels84815803b_o_tels
bother115218063b_other_
bottler94211883b_ottler_
bottles94216273b_ottles
bottomers1344353b_ottomers
bottoms1136993b_ottoms
botts75224863b_ott__s
bowers115523703b_o_wers
bowlers123715783b_owlers
bowyers15438733b_owyers
boxers155013483b_o_xers
boycotters1741913boycotters
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
brothels13277073brothels
brother123311333brother_
browsers13449203browsers
bruiters10329143bruiters
bunters94717123b_unters
bursters1038983bursters
busters94724133b_usters
bustiers103810053bustiers
bustlers104210613bustlers
butlers94518053b_utlers
butter84724233b_utter_
buttery124311193b_uttery
buttes84822563b_utte_s
calottes10610083calotte_s
chatters134213953chatters
chitters133711173chitters
clatter94014973clatter_
clattery13378193clattery
clobbers14397513clobbers
clockers16369813clockers
cloggers12437283cloggers
cloisters1137433cloisters
cloners94514823clo_ners
closers94415323clo_sers
clothes124513813clothe_s
clothiers1443423clothiers
clotted104011823clotte_d
clotures10299023clotures
clouter93511693clouter_
clovers125114663clo_vers
clowders14357473clowders
clusters102912403clusters
clutter94211663clutter_
cluttery13346323cluttery
clysters13227843clysters
coaters93525793_coaters
colters93522443_colters
cooters94525723_cooters
copters113621283_copters
costers94128333_costers
cottars94412243_cottars
cotter84926673_cotter_
cottiers10399153_cottiers
couters93827303_couters
critters103511323critters
crofters13358903crofters
culottes1076293culotte_s
cutters94218963_cutters
diopters1137693diopters
doters74423913_do_ters
dottels8327783_dottels
dotter74419343_dotter_
elaters74420193el_aters
eloiners8128153eloiners
elopers95112943elo_pers
emitters10349643emitters
emoters94712873emo_ters
fetters103517903_fetters
fitters104517753_fitters
flattens11357483flattens
flatter103815963flatter_
flattery14338293flattery
flirters11337933flirters
flitter103413903flitter_
floatels11295663floatels
floater104413353floater_
floggers13387863floggers
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
flossers11307863flossers
flouter104311343flouter_
flowers133413173flo_wers
flusters113811503flusters
fluters103713683fl_uters
flutter104012093flutter_
fluttery14376143fluttery
flytiers14254483flytiers
footers104618333_footers
footlers113910793footlers
fosters104220103_fosters
fretters113410303fretters
fritters113810783fritters
frothers14279813frothers
frotteurs1242223frotteurs
garotters1055033garotters
getters84216103_getters
glisters93912603glisters
glitter84211803glitter_
glittery12375613glittery
gloater83711013gloater_
glossers9319053glossers
glottis837173glott_is
glovers114310883glo_vers
glowers113412093glo_wers
goiters84014443_goiters
gritters94210633gritters
grouters95910083grouters
gutters83715513_gutters
hatters104221523_hatters
hitters104717593_hitters
holsters113211943holsters
hooters104520473_hooters
hotter94720083_hotter_
jitters144314473_jitters
jolters143711993_jolters
jotter134315633_jotter_
klisters123910483klisters
knitters12336623knitters
knotter11317643knotter_
lasters75627693_lasters
lathers104321883_lathers
lattens75014673_lattens
latter65027893_latter_
lattes65324203_latte_s
letter63722583_letter_
lifters104313783_lifters
linters73822633_linters
listers74026533_listers
liters65429883_l_iters
litter64324853_litter_
littery103710493_littery
loaders83413433_loaders
loafers10349463_loafers
loaners73913623_loaners
loathers113310443_loathers
lobbers113713943_lobbers
lobsters10268743_lobsters
locaters102710073_locaters
lockers133516923_lockers
lodgers95113833_lodgers
lofter94614723_lofter_
loggers94616133_loggers
loiter64619173_loiter_
lollers72713793_lollers
loners64225813_lo_ners
longers84819543_longers
lookers114014073_lookers
loopers93914033_loopers
looter64222323_looter_
lopers84424143_lo_pers
loppers113014103_loppers
losers65123583_lo_sers
lotte54923853_lotte__
lotted74222403_lotte_d
lotteries9311073_lotteries
lottos64613103_lott_os
louvers10359103_louvers
lovers94223433_lo_vers
lowers94624923_lo_wers
lusters73921443_lusters
matters94421753_matters
molters93816973_molters
mooters93818623_mooters
mothers123717623_mothers
mottes85523693_motte_s
mottlers10388183_mottlers
mutters94117143_mutters
natters73718063_natters
netters73618583_netters
noters64021003_no_ters
nutters74215433_nutters
oaters65029793__oaters
oldsters996733oldsters
omitters10277653omitters
others93918003__others
ottars64112223__ottars
otter54423973__otter_
outers64230173__outers
oxters134813273__oxters
patters94825193_patters
petters93722363_petters
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924093pl_aters
platter93917413platter_
pleaters103613793pleaters
plodders1235523plodders
plotless10256793plotless
plotted104612373plotte_d
plottier10327263plottier_
plotties103111413plotties
plotzes18317703plotze_s
plovers123611833plo_vers
plowers123812243plo_wers
poofters1336923poofters
porters93722703_porters
posters93928013_posters
pothers123818623_pothers
potter83926983_potter_
pottery123011073_pottery
potzers184010543_potzers
pouters94221873_pouters
powters124015663_powters
putters94219193_putters
quitters17238523quitters
quoters16369263quo_ters
ratters74422473_ratters
reletters9138783reletters
reutters8138573reutters
rioters73615513rio_ters
ritters74020623_ritters
roosters83514663roosters
rooters74522933_rooters
rosters73727543_rosters
rotter64325463_rotter_
rottes64524833_rotte_s
routers74822873_routers
scatters103612753scatters
scooters103511033scooters
scoters93313813sco_ters
scouters103411323scouters
scutters103311023scutters
setters73822063_setters
shatters113313913shatters
shooters112811583shooters
shouters113510623shouters
shutters113611353shutters
sitters74221553_sitters
skitters12349553skitters
slaters73123733sl_aters
slathers113914783slathers
slattern837093slattern
slatterns935363slatterns
slithers114212953slithers
slitter73615873slitter_
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093slo_pers
slotted84613883slotte_d
smatters104011713smatters
smothers13349933smothers
snorters83410583snorters
soothers113913433soothers
sorters74221133_sorters
souters74422603_souters
spatters103914703spatters
spitters104113383spitters
splatters11327543splatters
splitters11307323splitters
splutters11286273splutters
sporters103714063sporters
spotter94514883spotter_
spouters104011163spouters
sputters104012873sputters
stutters83210473stutters
swatters113911793swatters
swotter10399473swotter_
tatters74520483_tatters
tetters74320473_tetters
titters74219623_titters
tooters73818773_tooters
tootlers8289503tootlers
toters65026363_to_ters
totter65021463_totter_
tottery10388483_tottery
touters74018353_touters
trotter73312253trotter_
twitters11296773twitters
ulsters72711983ul_sters
utters63817123__utters
vetters104016323_vetters
voters95017443_vo_ters
wetters103817753_wetters
whetters14246653whetters
whitters14359403whitters
yatters103914623_yatters
zloties1639913zlotie_s
zosters163015413_zosters

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.420425454.8
2DLD Change Limit1461624777.37619815.9
3Display Results4774770.2032349.8
 (SQL Overall)1786914777.99922339.2
 
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.