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

443 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
clappers14331083(None) 
cappers134419401c_appers
clampers143211891clampers
clapper134011861clapper_
claspers124410911claspers
clippers14368841clippers
crappers144011021crappers
flappers15388381flappers
lappers113717461_lappers
slappers123710941slappers
calipers1249442calipers
campers134220292c_ampers
capers105428142c_a_pers
capper124421982c_apper_
carpers114521252c_arpers
champers173311622champers
chapters154012132chapters
chippers173510882chippers
choppers174110462choppers
clabbers14359902clabbers
clackers163911702clackers
claimers12298742claimers
clambers144211292clambers
clammers143510692clammers
clamper134012992clamper_
clangers114312342clangers
clapped143511172clappe_d
claquers19226202claquers
clashers134213992clashers
clasper113811862clasper_
classers104111832classers
clatters103313912clatters
clavers124314902cla_vers
claviers1367102claviers
clawers123910972cla_wers
clipper133710322clipper_
coappears1542952coappears
coppers133519752c_oppers
crapper133913192crapper_
croppers143311482croppers
cruppers14317322cruppers
cuppers133712212c_uppers
flapper14359202flapper_
flippers15338002flippers
floppers15337462floppers
knappers16315642knappers
lampers113817332_lampers
lapper104319952_lapper_
lappets11329122_lappets
lapsers93911052_lapsers
lippers113416442_lippers
loppers113014102_loppers
mappers133313782_mappers
nappers114214862_nappers
rappers113618442_rappers
sappers113518902_sappers
scrappers1545862scrappers
slapper113512462slapper_
slippers123711232slippers
snappers123510172snappers
swappers15358082swappers
tappers113416542_tappers
trappers123711042trappers
whappers18276742whappers
wrappers15306932wrappers
yappers144012252_yappers
zappers203911632_zappers
adapters1136103adapters
apers76629133__a_pers
appears11308953__appears
appels104312793__appels
aspers86220313__aspers
blabbers11308153blabbers
bladders12397803bladders
bladers104214683bla_ders
blamers115314213bla_mers
blasters104116143blasters
blathers134713793blathers
blatters104414093blatters
blazers184811683bla_zers
bleepers12377493bleepers
bloopers12397373bloopers
boppers133911923_boppers
cabers105023923c_a_bers
cablers114416713c_ablers
cadgers114712003c_adgers
cagers95624193c_a_gers
cahiers123510673c_ahiers
calibers1238523calibers
calipees1247413calipees
caliper11410963caliper_
calkers134414693c_alkers
callers94221963c_allers
callipers1356493callipers
caloyers1337343caloyers
calypters1643593calypters
cambers134017443c_ambers
camper124722213c_amper_
cancers114018583c_ancers
caners84629203c_a_ners
cankers134418753c_ankers
canners93822663c_anners
canoers94318373c_anoers
canters94827733c_anters
caper94831623c_a_per_
caperers122611723c_aperers
capes95441923c_a_pe_s
capless114312763c_apless
caplets114914523c_aplets
capped134721853c_appe_d
captors113914983c_aptors
carders104820353c_arders
careers95218783c_areers
carers85133963c_a_rers
carpels115315463c_arpels
carper104923633c_arper_
carpets113915333c_arpets
carters95327253c_arters
carvers124817543c_arvers
casters94729903c_asters
caters85336503c_a_ters
catnappers1682763catnappers
causers94014793c_ausers
cavers115026843c_a_vers
chafers154512743cha_fers
chaffers19378003chaffers
chambers173410623chambers
chamfers18409223chamfers
champer163813413champer_
chancers154313493chancers
changers144313203changers
chanters134016743chanters
chapels14429153cha_pels
chapes135421873cha_pe_s
chapiters1635203chapiters
chaplets1556883chaplets
chapped172711443chappe_d
chappies172610093chappies
chapter144213853chapter_
chargers144011323chargers
charmers154211333charmers
charters134115583charters
chasers123714923cha_sers
chatters134213953chatters
chaufers16347303chaufers
chawers154412053cha_wers
cheepers15329013cheepers
chipper163912583chipper_
chirpers15358133chirpers
chompers17369593chompers
chopper163611893chopper_
ciphers14379993c_iphers
clabber134210113clabber_
clacker153813773clacker_
clades94920463cla_de_s
claimer11279883claimer_
clamber133311743clamber_
clammer134211793clammer_
clamorers1345783clamorers
clamors11710093cla_mors
clamours1255993clamours
clamped144012043clampe_d
clamps124515083clamp__s
clanger104113493clanger_
clangors11417003clangors
clapping153810603clapping
claps95626183cla_p__s
claquer18287353claquer_
claques18279013claque_s
claqueurs20262063claqueurs
clarets94111103cla_rets
claries93422203clarie_s
claroes93113733claroe_s
clasher124615513clasher_
clashes124017283clashe_s
clasped123610443claspe_d
clasps104512093clasp__s
classer93614613classer_
classes94717943classe_s
clatter94014973clatter_
clattery13378193clattery
clauses93813323clause_s
claver113816973cla_ver_
claves115020063cla_ve_s
clavier1239173clavier_
clawer114512783cla_wer_
clawless1334123clawless
clayier1248323clayier_
claypans1543873claypans
cleaners103610543cleaners
cleansers11335073cleansers
clearers10349303clearers
cleavers13398873cleavers
clepes104214623cl_epe_s
clickers163910203clickers
climbers14318413climbers
clingers113810663clingers
clinkers14339833clinkers
clipped14439833clippe_d
clivers123411753cl_ivers
clobbers14397513clobbers
clockers16369813clockers
cloggers12437283cloggers
cloners94514823cl_oners
clopped143611523cloppe_d
closers94415323cl_osers
clouters10399803clouters
clovers125114663cl_overs
clowders14357473clowders
clubbers14378583clubbers
clumbers143910413clumbers
clunkers14327553clunkers
clusters102912403clusters
clutters103210353clutters
clypeus1433243cl_ypeus
clysters13227843clysters
coachers154312303coachers
coalers94419353coa_lers
coappear1442893coappear
coasters104317333coasters
coaters93525793coa_ters
coaxers164311083coa_xers
colanders1238013colanders
compeers143410013compeers
coopers114019483c_oopers
copers104629843c__opers
copiers114215963c_opiers
copper124321893c_opper_
copperas14308573c_opperas
coppery16409393c_oppery
copters113621283c_opters
couplers123311323couplers
crabbers14358753crabbers
crackers164111723crackers
cradlers11309203cradlers
crafters13419953crafters
crammers14369353crammers
crapes104727693cra_pe_s
crapped143912623crappe_d
crappier14288133crappier_
crappies142911153crappies
crashers134013233crashers
craters95021893cra_ters
cravers124416563cra_vers
crawlers13309013crawlers
creepers12318633creepers
crimpers14318933crimpers
cripplers15314993cripplers
crispers12309433crispers
cropper133312963cropper_
crupper13338563crupper_
cupper124313863c_upper_
curlpapers1641433curlpapers
cyphers17316753c_yphers
dampers123915693_dampers
dapper114016633_dapper_
diapers104713913dia_pers
didappers1543173didappers
dippers123615183_dippers
drapers105313353dra_pers
drippers13327943drippers
droppers13318603droppers
eclipsers1342643eclipsers
elapses957663elapse_s
elaters74420193ela_ters
elopers95112943el_opers
flaggers13328073flaggers
flakers143613273fla_kers
flamers124616363fla_mers
flangers123311373flangers
flankers15349303flankers
flapless1335343flapless
flapped15328253flappe_d
flappier1544293flappier_
flashers143912653flashers
flatters113814203flatters
flayers133912033fla_yers
flipper14389143flipper_
flopper14328473flopper_
flypapers1942033flypapers
frappes14328383frappe_s
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
gippers123212083_gippers
glaciers11277893glaciers
glancers11408003glancers
glanders103811503glanders
glazers174410043gla_zers
glaziers18406563glaziers
grapplers14274303grapplers
graspers11338403graspers
grippers13358133grippers
gyppers15235503_gyppers
hampers143616953_hampers
happens14359173_happens
harpers124916203_harpers
heapers123616673hea_pers
hoppers143115143_hoppers
japers154616173_ja_pers
jaspers164310463_jaspers
kippers153211433_kippers
knapper15387153knapper_
laagers83411253_laagers
lacers85225253_la_cers
lackers134120543_lackers
ladders94115173_ladders
laders74927763_la_ders
ladlers84613573_ladlers
lagers74826143_la_gers
laggers94216243_laggers
lakers105225153_la_kers
lambers113817113_lambers
lancers93616643_lancers
landers84026213_landers
lanners73618333_lanners
lapels83712043_la_pels
lapped114320033_lappe_d
lappered13288213_lappered
lappet103817723_lappe_t
lapser84113143_lapser_
lapses85217693_lapse_s
larders83516943_larders
larkers113014513_larkers
lasers64925703_la_sers
lashers104121833_lashers
lasters75627693_lasters
lathers104321883_lathers
lauders84012893_lauders
laveers10329363_laveers
lavers94526363_la_vers
lawyers13377153_lawyers
layers93921183_la_yers
leapers93716663_leapers
lepers84817323_l_epers
limpers113815223_limpers
lippens11328533_lippens
lipper104219633_lipper_
lispers94514323_lispers
loopers93914033_loopers
lopers84424143_l_opers
lopper103717203_lopper_
lumpers113514483_lumpers
mapper124516093_mapper_
moppers133412463_moppers
napper103718283_napper_
nappes104515623_nappe_s
nippers113012623_nippers
oilpapers1342833oilpapers
pampers133615933_pampers
papers105125323_pa_pers
paupers114311073_paupers
peppers103311443_peppers
placers114515263pla_cers
plaguers11286503plaguers
plaiters103512633plaiters
planers94517943pla_ners
planners10399933planners
planters102915323planters
plashers133813453plashers
plasters103518133plasters
platers93924093pla_ters
platters103415283platters
players124313763pla_yers
playpens1534073playpens
plumpers14357293plumpers
poppers103414863_poppers
quippers2184813quippers
rapers84327183_ra_pers
rapiers95012873_rapiers
rappees113611453_rappees
rappels11448803_rappels
rapper104621573_rapper_
raspers94415923_raspers
reapers93520453rea_pers
reappears1342853reappears
relapsers1164123relapsers
repapers1258833repapers
rippers114115033_rippers
sapper103822353_sapper_
scalpers123710863scalpers
scampers143611033scampers
scarpers124712513scarpers
scaupers12378173scaupers
schappes1736033schappe_s
schnappers1942143schnappers
sclaffers17122523sclaffers
scrapers125510533scra_pers
scrapper1466973scrapper_
scuppers1446543scuppers
shapers124016893sha_pers
sharpers133810943sharpers
shippers153012313shippers
shoppers153010763shoppers
sippers113117753_sippers
skippers16318203skippers
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slanders94014013slanders
slapped123511843slappe_d
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
sleepers103110113sleepers
slipper113712983slipper_
slippery15275863slippery
slopers94213093sl_opers
snapper113512073snapper_
snippers12299723snippers
soapers93715923soa_pers
stampers124211603stampers
staplers103111203staplers
steppers12289283steppers
stoppers123910593stoppers
strappers1346743strappers
suppers113314703_suppers
swampers15317473swampers
swapper14359703swapper_
tampers113516743_tampers
tapers84025813_ta_pers
tapper104419613_tapper_
tappets113610013_tappets
tippers113414353_tippers
toppers113914603_toppers
trampers123210393trampers
trapper113912803trapper_
trippers123210163trippers
uppers102912293__uppers
vampers143111623_vampers
warpers123413583_warpers
whapper17348273whapper_
whippers18329043whippers
whoppers18297533whoppers
wrapper14368333wrapper_
yapper133714513_yapper_
yaupers12337663_yaupers
yawpers15346853_yawpers
zapper193414023_zapper_
zippers203310383_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.500357382.0
2DLD Change Limit1461624437.48619524.7
3Display Results4434430.1732560.7
 (SQL Overall)1786914438.15921901.1
 
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.