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

485 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
flapper1435920(None) 
clapper134011861clapper
flapped15328251flapped
flappers15388381flappers
flappier1544291flappier
flipper14389141flipper
flopper14328471flopper
lapper104319951_lapper
slapper113512461slapper
capper124421982_capper
clamper134012992clamper
clapped143511172clapped
clappers143310832clappers
clasper113811862clasper
clipper133710322clipper
crapper133913192crapper
dapper114016632_dapper
flagger12469352flagger
flaker134916172fla_ker
flakier143910202flakier
flamer114919122fla_mer
flamier123112142flamier
flanger113412622flanger
flanker143911292flanker
flappy1654482flapp_y
flasher133914062flasher
flatter103815962flatter
flawier13378732flawier
flaxier17337982flaxier
flayer124713562fla_yer
flipped15358512flipped
flippers15338002flippers
flopped15338762flopped
floppers15337462floppers
floppier1554632floppier
flypaper1842222flypaper
frappe13286952frappe_
frapped15318852frapped
frappes14328382frappes
knapper15387152knapper
lapped114320032_lapped
lappers113717462_lappers
lappet103817722_lappet
lapser84113142_lapser
lipper104219632_lipper
lopper103717202_lopper
mapper124516092_mapper
napper103718282_napper
rapper104621572_rapper
sapper103822352_sapper
slapped123511842slapped
slappers123710942slappers
slipper113712982slipper
snapper113512072snapper
swapper14359702swapper
tapper104419612_tapper
trapper113912802trapper
whapper17348272whapper
wrapper14368332wrapper
yapper133714512_yapper
zapper193414022_zapper
adapter1036173adapter
aper66336233__a_per
appear10379343__appear
appel94615893__appel
apter76120203__apter
asper75520433__asper
blabber10418923blabber
blacker154513513blacker
bladder11429153bladder
blader93618583bla_der
blamer104417143bla_mer
blander103715163blander
blanker134612023blanker
blaster94017303blaster
blather125314203blather
blatter94415653blatter
blazer174414023bla_zer
bleeper11458253bleeper
blipped14377193blipped
blooper11358533blooper
bopper123813833_bopper
caliper11410963caliper
camper124722213_camper
caper94831623_ca_per
capped134721853_capped
cappers134419403_cappers
carper104923633_carper
champer163813413champer
chapped172711443chapped
chapter144213853chapter
chipper163912583chipper
chopper163611893chopper
clabber134210113clabber
clacker153813773clacker
claimer11279883claimer
clamber133311743clamber
clammer134211793clammer
clamped144012043clamped
clampers143211893clampers
clanger104113493clanger
claquer18287353claquer
clasher124615513clasher
clasped123610443clasped
claspers124410913claspers
classer93614613classer
clatter94014973clatter
claver113816973cla_ver
clavier1239173clavier
clawer114512783cla_wer
clayier1248323clayier
clipped14439833clipped
clippers14368843clippers
clopped143611523clopped
coappear1442893coappear
copper124321893_copper
crapped143912623crapped
crappers144011023crappers
crappier14288133crappier
cropper133312963cropper
crupper13338563crupper
cupper124313863_cupper
damper114117753_damper
dapped124516763_dapped
diaper94513113dia_per
didapper1442953didapper
dipper114017793_dipper
draper94315693dra_per
dripper12349233dripper
dropper12329873dropper
elapse857523elapse_
elapsed1056103elapsed
elapses957663elapses
elater64724203ela_ter
eloper85414153el_oper
fabber134814113f_abber
fabler116115813f_abler
facer105525053f_a_cer
fader94421513f_a_der
fainer94717243f_ainer
fairer95212063f_airer
fakeer13378743f_akeer
faker124824593f_a_ker
faller94621233f_aller
falser93912413f_alser
falter94519053f_alter
fanner94218183f_anner
farcer115016083f_arcer
farer86733143f_a_rer
farmer115017373f_armer
faster94625773f_aster
father125116713f_ather
fatter94523213f_atter
fawner125910463f_awner
fearer94820183fea_rer
feaster10812983feaster
feater95224053fea_ter
feather133613503feather
flabbier1534093flabbier
flacked173711583flacked
flackery20295243flackery
flagged13459633flagged
flaggers13328073flaggers
flaggier13105203flaggier
flagmen13226913flagmen
flailed1137303flailed
flair86114123fla__ir
flake125119973fla_ke_
flaked144715653fla_ked
flakers143613273fla_kers
flakes134118873fla_kes
flakey164410513fla_key
flambe13489153flambe_
flambee144210013flambee
flambes14419503flambes
flame105124443fla_me_
flamed124618973fla_med
flamen115215993fla_men
flamers124616363fla_mers
flames114723693fla_mes
flammed15377413flammed
flanes94522423fla_nes
flaneur1034183flaneur
flange103411973flange_
flanged123810843flanged
flangers123311373flangers
flanges113413273flanges
flanked153710643flanked
flanken14226763flanken
flankers15349303flankers
flannel1035423flannel
flap96128703fla_p__
flaperon13124843fla_peron
flapless1335343flapless
flappiest1644853flappiest
flapping16298153flapping
flaps105621383fla_p_s
flare84823633fla_re_
flared105317603fla_red
flares94521703fla_res
flashed144112183flashed
flashers143912653flashers
flashes133916103flashes
flashier1437103flashier
flasket1439733flasket
flatbed13397983flatbed
flatcar1274613flatcar
flatlet10312253flatlet
flatted114012943flatted
flatten10429653flatten
flatters113814203flatters
flattery14338293flattery
flaunter1135013flaunter
flavor1236663fla_vor
flavorer1454553flavorer
flavour1334633flavour
flawed134712723fla_wed
flaxen16518573fla_xen
flaxes165015353fla_xes
flayed134414053fla_yed
flayers133912033fla_yers
fleahopper2051583fleahopper
fleecer12368033fleecer
fleer86020773fl__eer
fleeter103210363fleeter
flenser1036783flenser
flesher133610923flesher
flicker163610623flicker
flier86023403fl__ier
flinder11319873flinder
flinger113710513flinger
flippest1535173flippest
flippy1654613flipp_y
flirter10318673flirter
flitter103413903flitter
flivver1633043flivver
floater104413353floater
floatier1136983floatier
flogger12449463flogger
flooder11258463flooder
floorer10248073floorer
flopover1642863flopover
floppies1546813floppies
floppy1654873flopp_y
flosser10339693flosser
flouter104311343flouter
flower124815503fl_ower
flubber14287713flubber
fluffer12336503fluffer
flukier14397853flukier
flumped15377713flumped
flunker14389363flunker
flusher133012273flusher
fluster103913063fluster
fluter95316863fl_uter
flutier103011553flutier
flutter104012093flutter
flyer114916253fl__yer
flyover1633513flyover
flypapers1942033flypapers
flytier13356503flytier
foamer114714313foa_mer
foamier12339003foamier
fopped144012673f_opped
foppery17385623f_oppery
frailer10319943frailer
framer114817443fra_mer
franker143510183franker
frater94520593fra_ter
frippery1832953frippery
gaper86125123_ga_per
gapped124217123_gapped
gappier12369843_gappier
gasper94515543_gasper
gawper12499693_gawper
gipper114215303_gipper
glacier103911293glacier
gladder10398313gladder
gladier93810993gladier
glancer103710073glancer
glarier84112203glarier
glazer164212263gla_zer
glazier17409353glazier
glopped13347613glopped
gloppier1354673gloppier
grapier103712603grapier
grappler13336193grappler
grasper10389793grasper
gripper124410713gripper
gypper14347293_gypper
hamper134518653_hamper
happed144820103_happed
happen134812193_happen
happier143312033_happier
harper115018403_harper
heaper114119523hea_per
hepper133412663_hepper
hipper133818023_hipper
hopper134218483_hopper
japer146218883_ja_per
jasper154610383_jasper
kipper143414213_kipper
knapped16397103knapped
knappers16315643knappers
laager74312783_laager
lacer75833753_la_cer
lacier84020093_lacier
lacker125325623_lacker
ladder84617623_ladder
lader65633723_la_der
ladler74314933_ladler
lager65132863_la_ger
lagger85919833_lagger
laker95432873_la_ker
lakier104716273_lakier
lamber104418493_lamber
lamer75233703_la_mer
lamped114017543_lamped
lampers113817333_lampers
lancer84319973_lancer
lander74028483_lander
lanker104123003_lanker
lanner64920603_lanner
lapel73716683_la_pel
lappered13288213_lappered
lappets11329123_lappets
lapse74917683_lapse_
lapsed94712583_lapsed
lapsers93911053_lapsers
lapses85217693_lapses
larder73720973_larder
larger74417513_larger
larker104519243_larker
laser54633323_la_ser
lasher94824533_lasher
laster64830633_laster
later54843923_la_ter
lather95124353_lather
latter65027893_latter
lauder73815013_lauder
laveer94110423_laveer
laver85031793_la_ver
lawyer12386973_lawyer
laxer125420333_la_xer
layer84626473_la_yer
lazier154214613_lazier
leaper88118943_leaper
leper74820743_l_eper
limper104117853_limper
lipped114419543_lipped
lippen103911403_lippen
lippers113416443_lippers
lippier112710573_lippier
lisper84114433_lisper
looper83817113_looper
loper75129233_l_oper
lopped114218623_lopped
loppers113014103_loppers
loppier11369723_loppier
lumper103816653_lumper
mapped134015883_mapped
mappers133313783_mappers
mopper126215003_mopper
nappe96114993_nappe_
napped114218163_napped
nappers114214863_nappers
nappes104515623_nappes
nappier114411173_nappier
nipper103715713_nipper
oilpaper1242853oilpaper
pamper124316663_pamper
paper95128663_pa_per
pappier103511593_pappier
pauper103511943_pauper
pepper93512943_pepper
placer105117743pla_cer
plaguer10328273plaguer
plainer93811983plainer
plaiter93615393plaiter
planer84122653pla_ner
planner93511623planner
planter94017803planter
plasher124215033plasher
plaster93318693plaster
plater84427693pla_ter
platier93716293platier
platter93917413platter
player115215213pla_yer
playpen1434693playpen
plopped11288773plopped
plumper13318773plumper
popper93615963_popper
quipper2095823quipper
raper74932753_ra_per
rapier84019993_rapier
rapped114122683_rapped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rappers113618443_rappers
rasper83917333_rasper
reaper84223143rea_per
reappear1242623reappear
relapser1035273relapser
repaper11310023repaper
ripper103518653_ripper
sapped114422013_sapped
sappers113518903_sappers
sappier113613113_sappier
scalper113912923scalper
scamper134613163scamper
scarper114814823scarper
scauper11379453scauper
scrapper1466973scrapper
scupper1367423scupper
shaper114119933sha_per
sharper124312703sharper
shipper143514043shipper
shopper143312633shopper
sipper103920993_sipper
skipper15339573skipper
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slammer113913033slammer
slander84015443slander
slasher104515333slasher
slater64429183sla_ter
slather103816073slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
sleeper93211563sleeper
slipped124711743slipped
slippers123711233slippers
slippery15275863slippery
slippier1256533slippier
sloper84615913sl_oper
slopped123511443slopped
sloppier1255703sloppier
snapped124611203snapped
snappers123510173snappers
snappier1266213snappier
snipper113911333snipper
soaper84517873soa_per
soapier93411713soapier
stamper113714403stamper
stapler93913633stapler
stepper113010853stepper
stopper113012603stopper
strapper1258093strapper
supper104115433_supper
swamper14349313swamper
swapped15429143swapped
swappers15358083swappers
tamper104618513_tamper
taper74829773_ta_per
tapped113820053_tapped
tappers113416543_tappers
tappet103820113_tappet
tipper103918413_tipper
topper103817603_topper
tramper113812163tramper
trapped124512213trapped
trappers123711043trappers
tripper113711923tripper
unflapped1743093unflapped
upper93714263__upper
vamper134212653_vamper
wapped144416473_wapped
warper114015583_warper
whapped18367573whapped
whappers18276743whappers
whipper173611383whipper
whopper17328503whopper
wrapped15338023wrapped
wrappers15306933wrappers
yapped144415143_yapped
yappers144012253_yappers
yauper11368543_yauper
yawper14437953_yawper
zapped204213523_zapped
zappers203911633_zappers
zappier20458373_zappier
zipper193813123_zipper

Search took 7 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.390458182.1
2DLD Change Limit1340274855.72023431.3
3Display Results4854850.1732803.5
 (SQL Overall)1786914856.28328440.4
 
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.