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

370 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
flappers1538838(None) 
clappers143310831clappers
flapper14359201flapper_
flippers15338001flippers
floppers15337461floppers
lappers113717461_lappers
slappers123710941slappers
cappers134419402_cappers
clampers143211892clampers
clapper134011862clapper_
claspers124410912claspers
clippers14368842clippers
crappers144011022crappers
flaggers13328072flaggers
flakers143613272fla_kers
flamers124616362fla_mers
flangers123311372flangers
flankers15349302flankers
flapless1335342flapless
flapped15328252flappe_d
flappier1544292flappier_
flashers143912652flashers
flatters113814202flatters
flayers133912032fla_yers
flipper14389142flipper_
flopper14328472flopper_
flypapers1942032flypapers
frappes14328382frappe_s
knappers16315642knappers
lampers113817332_lampers
lapper104319952_lapper_
lappets11329122_lappets
lapsers93911052_lapsers
lippers113416442_lippers
loppers113014102_loppers
mappers133313782_mappers
nappers114214862_nappers
rappers113618442_rappers
sappers113518902_sappers
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
calipers1249443calipers
campers134220293_campers
capers105428143_ca_pers
capper124421983_capper_
carpers114521253_carpers
champers173311623champers
chapters154012133chapters
chippers173510883chippers
choppers174110463choppers
clabbers14359903clabbers
clackers163911703clackers
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clamper134012993clamper_
clangers114312343clangers
clapped143511173clappe_d
claquers19226203claquers
clashers134213993clashers
clasper113811863clasper_
classers104111833classers
clatters103313913clatters
clavers124314903cla_vers
claviers1367103claviers
clawers123910973cla_wers
clipper133710323clipper_
coappears1542953coappears
coppers133519753_coppers
crapper133913193crapper_
croppers143311483croppers
cruppers14317323cruppers
cuppers133712213_cuppers
dampers123915693_dampers
dapper114016633_dapper_
diapers104713913dia_pers
didappers1543173didappers
dippers123615183_dippers
drapers105313353dra_pers
drippers13327943drippers
droppers13318603droppers
elapses957663elapse_s
elaters74420193ela_ters
elopers95112943el_opers
fablers124812613f_ablers
facers115519443f_a_cers
faders105117463f_a_ders
fakeers14446673f_akeers
fakers134219533f_a_kers
fallers103917993f_allers
falters103916473f_alters
fanners103914653f_anners
farcers124713443f_arcers
farers95924053f_a_rers
farmers124315263f_armers
fathers133916503f_athers
fawners13388493f_awners
fearers104815273fea_rers
feasters11511563feasters
feathers143513243feathers
flackery20295243flackery
flagger12469353flagger_
flagless1235403flagless
flairs95711913fla__irs
flaker134916173fla_ker_
flakes134118873fla_ke_s
flakier143910203flakier_
flambes14419503flambe_s
flamens124611063fla_mens
flamer114919123fla_mer_
flames114723693fla_me_s
flamier123112143flamier_
flanes94522423fla_ne_s
flaneurs1133953flaneurs
flanger113412623flanger_
flanges113413273flange_s
flanker143911293flanker_
flannels1134843flannels
flaperon13124843fla_peron
flaperons14125043fla_perons
flappiest1644853flappiest
flapping16298153flapping
flappy1654483flapp__y
flaps105621383fla_p__s
flares94521703fla_re_s
flasher133914063flasher_
flashes133916103flashe_s
flaskets1534603flaskets
flatbeds14364543flatbeds
flatcars1344623flatcars
flatlets1147373flatlets
flatness1138153flatness
flattens11357483flattens
flatter103815963flatter_
flattery14338293flattery
flaunters1234513flaunters
flavorers1563983flavorers
flavors1337293fla_vors
flavours1434693flavours
flawier13378733flawier_
flawless1434503flawless
flaxes165015353fla_xe_s
flaxier17337983flaxier_
flayer124713563fla_yer_
fleahoppers2151603fleahoppers
fleecers13325933fleecers
fleers96015793fl__eers
flensers1135463flensers
fleshers14339443fleshers
flickers17338883flickers
fliers94417193fl__iers
flinders12439263flinders
flingers123410193flingers
flipped15358513flippe_d
flippest1535173flippest
flirters11337933flirters
flitters114312173flitters
flivvers1733113flivvers
floaters112711513floaters
floggers13387863floggers
flooders12257833flooders
floorers11227573floorers
flopovers1742563flopovers
flopped15338763floppe_d
floppier1554633floppier_
floppies1546813floppies
flossers11307863flossers
flouters11419273flouters
flowers133413173fl_owers
flubbers15346893flubbers
fluffers13335293fluffers
flunkers15347533flunkers
flushers14279733flushers
flusters113811503flusters
fluters103713683fl_uters
flutters114010823flutters
flyers125712803fl__yers
flyovers1733673flyovers
flypaper1842223flypaper_
flytiers14254483flytiers
foamers123812103foa_mers
foppery17385623f_oppery
framers125113823fra_mers
frankers15348353frankers
frappe13286953frappe__
frapped15318853frappe_d
fraters103517213fra_ters
frippery1832953frippery
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
scrappers1545863scrappers
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 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 Filter1786911461620.406440125.6
2DLD Change Limit1461623707.39019778.3
3Display Results3703700.1562371.8
 (SQL Overall)1786913707.95222471.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.