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

457 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
flapped1532825(None) 
clapped143511171clapped
flapper14359201flapper
flipped15358511flipped
flopped15338761flopped
frapped15318851frapped
lapped114320031_lapped
slapped123511841slapped
blipped14377192blipped
capped134721852_capped
chapped172711442chapped
clamped144012042clamped
clapper134011862clapper
clasped123610442clasped
clipped14439832clipped
clopped143611522clopped
crapped143912622crapped
dapped124516762_dapped
elapsed1056102elapsed
flacked173711582flacked
flagged13459632flagged
flailed1137302flailed
flaked144715652fla_ked
flamed124618972fla_med
flammed15377412flammed
flanged123810842flanged
flanked153710642flanked
flappers15388382flappers
flappier1544292flappier
flappy1654482flapp_y
flared105317602fla_red
flashed144112182flashed
flatbed13397982flatbed
flatted114012942flatted
flawed134712722fla_wed
flayed134414052fla_yed
flipper14389142flipper
flopper14328472flopper
flumped15377712flumped
fopped144012672f_opped
frappe13286952frappe_
frappes14328382frappes
gapped124217122_gapped
glopped13347612glopped
happed144820102_happed
knapped16397102knapped
lamped114017542_lamped
lapper104319952_lapper
lappet103817722_lappet
lapsed94712582_lapsed
lipped114419542_lipped
lopped114218622_lopped
mapped134015882_mapped
napped114218162_napped
plopped11288772plopped
rapped114122682_rapped
sapped114422012_sapped
slapper113512462slapper
slipped124711742slipped
slopped123511442slopped
snapped124611202snapped
swapped15429142swapped
tapped113820052_tapped
trapped124512212trapped
unflapped1743092unflapped
wapped144416472_wapped
whapped18367572whapped
wrapped15338022wrapped
yapped144415142_yapped
zapped204213522_zapped
adapted1135833adapted
alarmed1037733alarmed
alated75625143ala_ted
aliped95414283al_iped
amped104820513__amped
aped78538153__a_ped
appel94615893__appel
append1138273__append
becapped1733933becapped
blabbed11357813blabbed
blacked163613373blacked
bladed104717763bla_ded
blamed116017953bla_med
blanked144011223blanked
blared95018243bla_red
blasted104213473blasted
blatted104812713blatted
blawed124713893bla_wed
blazed184314713bla_zed
bleeped12287273bleeped
blooped12398543blooped
bopped134413403_bopped
camped134720233_camped
caped104931803_ca_ped
capper124421983_capper
carped115923763_carped
champed174111473champed
chipped174110813chipped
chopped174511003chopped
clacked164113603clacked
cladded12356923cladded
clagged12749233clagged
claimed12298833claimed
clammed14369963clammed
clamper134012993clamper
clanged114212653clanged
clanked143812253clanked
clappers143310833clappers
clashed133614013clashed
clasper113811863clasper
classed104113653classed
clawed125115073cla_wed
clayed125013043cla_yed
cleped115114113cl_eped
clipper133710323clipper
clomped14398973clomped
clumped143610663clumped
coapted123911493coapted
copped135221253_copped
cramped144712183cramped
craped116120523cra_ped
crapper133913193crapper
cropped143812063cropped
cupped134413983_cupped
damped124315583_damped
dapper114016633_dapper
dappled1336393_dappled
dewlapped1841953dewlapped
dipped123517493_dipped
draped105314363dra_ped
dripped13408083dripped
dropped13329283dropped
dupped124411643_dupped
elapid939543ela_pid
elapse857523elapse_
elapses957663elapses
elated74725823ela_ted
eloped95914143el_oped
exapted1736073exapted
fabled124216383f_abled
faced117727653f_a_ced
faded105025243f_a_ded
fadged124712353f_adged
fagged124717703f_agged
failed105421603f_ailed
faired105915773f_aired
faked135225483f_a_ked
famed115928343f_a_med
fanged114318223f_anged
fanned104117473f_anned
farced125216533f_arced
farded114518953f_arded
fared95842343f_a_red
farmed125117653f_armed
farted105121783f_arted
fashed136720253f_ashed
fasted105320953f_asted
fated95632133f_a_ted
fatted105419843f_atted
fawned134910423f_awned
faxed166220533f_a_xed
fayed126422153f_a_yed
fazed186222963f_a_zed
feared106320433fea_red
feased105718713fea_sed
feasted11310843feasted
feazed195112633fea_zed
filliped1435223filliped
flaccid1544393flaccid
flagger12469343flagger
flagmen13226913flagmen
flake125119973fla_ke_
flaker134916173fla_ker
flakes134118873fla_kes
flakey164410513fla_key
flakier143910203flakier
flambe13489153flambe_
flambee144210013flambee
flambeed16324383flambeed
flambes14419503flambes
flame105124443fla_me_
flamen115215993fla_men
flamer114919123fla_mer
flames114723693fla_mes
flamier123112143flamier
flanes94522423fla_nes
flange103411973flange_
flanger113412623flanger
flanges113413273flanges
flanken14226763flanken
flanker143911293flanker
flannel1035423flannel
flap96128703fla_p__
flapless1335343flapless
flappiest1644853flappiest
flapping16298153flapping
flaps105621383fla_p_s
flare84823633fla_re_
flares94521703fla_res
flasher133914063flasher
flashes133916103flashes
flasket1439733flasket
flatbeds14364543flatbeds
flathead1535803flathead
flatlet10312253flatlet
flatten10429653flatten
flatter103815963flatter
flaunted1234603flaunted
flavored1554573flavored
flawier13378733flawier
flaxen16518573fla_xen
flaxes165015353fla_xes
flaxier17337983flaxier
flaxseed1942573flaxseed
flayer124713563fla_yer
flecked17358073flecked
fled85429773fl___ed
fledged13417843fledged
fleeced13358153fleeced
fleered11309503fleered
fleeted113310233fleeted
flensed1136613flensed
fleshed143210263fleshed
flexed17419083fl_exed
fleyed13408813fl_eyed
flicked174610673flicked
flied96519433fl__ied
flinted114411893flinted
flippers15337993flippers
flippest1535173flippest
flippy1654613flipp_y
flirted11428673flirted
flited104616583fl_ited
flitted114011643flitted
floated113312703floated
flocced15365483flocced
flocked174510253flocked
flogged13528803flogged
flooded12307933flooded
floored11268683floored
floppers15337463floppers
floppier1554633floppier
floppies1546813floppies
floppy1654873flopp_y
flossed11388533flossed
floured11289873floured
flouted113210813flouted
flowed133513763fl_owed
flubbed15306633flubbed
flued95021253fl__ued
fluffed13295903fluffed
fluked145112093fl_uked
flumed124915263fl_umed
flunked15398413flunked
flushed143310973flushed
fluted104917163fl_uted
fluxed17509673fl_uxed
flypaper1842223flypaper
flyted13378773fl_yted
foaled104515963foa_led
foamed126014403foa_med
fracted1339373fracted
fragged134010153fragged
framed125116523fra_med
franked153610053franked
frayed135012163fra_yed
galoped11138063galoped
gaped96123533_ga_ped
gasped104814293_gasped
gawped13509073_gawped
gipped124815903_gipped
glaceed1136193glaceed
gladded11357453gladded
glaired9387743glaired
glaived12375973glaived
glanced11439233glanced
glared84715193gla_red
glassed93710433glassed
glazed174711773gla_zed
graphed1498473graphed
grappled14336093grappled
grasped11409063grasped
gripped13419343gripped
gypped15377113_gypped
happen134812193_happen
harped124418403_harped
hasped125014443_hasped
heaped124516903hea_ped
hipped144317693_hipped
hopped144318113_hopped
japed156217633_ja_ped
jauped16457903_jauped
kepped15309533_kepped
kipped153114573_kipped
knapper15387153knapper
knopped16355443knopped
laced87132643_la_ced
lacked135324653_lacked
laded74232613_la_ded
ladled85013483_ladled
lagged95520133_lagged
laired75216813_laired
laked105731123_la_ked
lalled74218753_lalled
lambed115614783_lambed
lamed85235293_la_med
lammed113915623_lammed
lampad114510033_lampad
lanced93717723_lanced
landed84619243_landed
lapel73716683_la_pel
lapeled10258893_lapeled
lappered13288213_lappered
lappers113717463_lappers
lappeted13255833_lappeted
lappets11329123_lappets
lapse74917683_lapse_
lapser84113143_lapser
lapses85217693_lapses
larded84319093_larded
larked114519473_larked
lased65132343_la_sed
lashed105625213_lashed
lasted74323603_lasted
lated65240673_la_ted
lathed104718453_lathed
lauded83812153_lauded
laved95028593_la_ved
lawed96028323_la_wed
layed95127383_la_yed
lazed154925843_la_zed
lazied164610653_lazied
leaped94317773_leaped
limped114817123_limped
lippen103911403_lippen
lipper104219633_lipper
lisped94113423_lisped
looped95217173_looped
loped85128333_l_oped
lopper103717203_lopper
louped95316383_louped
lumped114216963_lumped
mapper124516093_mapper
mopped134114323_mopped
nappe96114993_nappe_
napper103718283_napper
nappes104515623_nappes
nipped113615853_nipped
palped114513643_palped
pepped103113393_pepped
pipped104516543_pipped
placed114318003pla_ced
plagued11307473plagued
plaided11409643plaided
plained103812233plained
plaited103713893plaited
planed94420913pla_ned
planked143512283planked
planned103810153planned
planted103516123planted
plashed133712643plashed
plated95225773pla_ted
platted103614263platted
played124815033pla_yed
playpen1434693playpen
plumped14318643plumped
popped104117813_popped
prepped11329893prepped
propped113311953propped
pupped105013273_pupped
quipped2175163quipped
ralphed1334363ralphed
ramped114617903_ramped
raped85334623_ra_ped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rapper104621573_rapper
rasped94715203_rasped
reaped94122453rea_ped
recapped1535943recapped
relapsed1136523relapsed
remapped1534913remapped
repped114616723_repped
ripped114419013_ripped
sapper103822353_sapper
scalped124411993scalped
scamped144711963scamped
scaped115519553sca_ped
scarped124314393scarped
scrapped1556533scrapped
shaped125020103sha_ped
sharped134112043sharped
shipped153312103shipped
shlepped1633643shlepped
shopped153512203shopped
sipped113720633_sipped
skipped16358403skipped
slabbed12409503slabbed
slacked143815453slacked
slagged104312763slagged
slaked114318273sla_ked
slammed123511103slammed
slanged94112853slanged
slanted83514743slanted
slappers123710933slappers
slashed114114853slashed
slated75028313sla_ted
slatted84015183slatted
slaved104017043sla_ved
slayed104716223sla_yed
sliped95417063sl_iped
slipper113712973slipper
sloped94216853sl_oped
slumped123710153slumped
slurped10368753slurped
snapper113512073snapper
snipped123510043snipped
soaped95817973soa_ped
sopped114819903_sopped
stamped124812813stamped
stapled103613693stapled
stepped123210053stepped
stopped124512203stopped
strapped1357813strapped
supped114415703_supped
swamped15498443swamped
swapper14359703swapper
swopped15437673swopped
taliped1078203taliped
tamped114317043_tamped
taped85327423_ta_ped
tapper104419613_tapper
tappet103820113_tappet
tipped114418263_tipped
topped114617723_topped
tramped124312433tramped
trapper113912793trapper
tripped123911693tripped
tupped114013233_tupped
uncapped1556693uncapped
unmapped1535173unmapped
untapped1376613untapped
upped103715163__upped
vamped144211013_vamped
warped124816413_warped
whapper17348273whapper
whipped18379333whipped
whopped18358003whopped
whupped18365413whupped
wrapper14368333wrapper
yapper133714513_yapper
yauped12408333_yauped
yawped15528103_yawped
yipped143613283_yipped
zapper193414023_zapper
zipped203612983_zipped

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 Filter1786911340270.310576422.6
2DLD Change Limit1340274578.12616493.6
3Display Results4574570.1562929.5
 (SQL Overall)1786914578.59220797.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.