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

434 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
clapping15381060(None) 
capping143819671c_apping
chapping183710721chapping
clamping154011151clamping
clasping133310261clasping
clipping15349151clipping
clopping153511081clopping
crapping153911451crapping
flapping16298151flapping
lapping124117021_lapping
slapping133510831slapping
blipping15306802blipping
camping143118972c_amping
cappings15369492c_appings
carping123521082c_arping
champing183610932champing
chipping18389792chipping
chopping183710262chopping
clacking173313492clacking
cladding1337142cladding
clagging13328872clagging
claiming13279302claiming
clamming15329372clamming
clanging124012122clanging
clanking154313062clanking
clashing143812192clashing
classing113211792classing
clawing133812672cla_wing
claying133614302cla_ying
cleping123310422cl_eping
clippings16273752clippings
clomping15329652clomping
clumping15319882clumping
coapting133511612coapting
copping143918592c_opping
cramping153411852cramping
craping124018712cra_ping
cropping153210882cropping
cupping144312382c_upping
dapping133714792_dapping
elapsing1146712elapsing
flipping16307662flipping
flopping16388772flopping
frapping16348102frapping
gapping134214782_gapping
glopping14307752glopping
happing153817232_happing
knapping17314972knapping
lamping123116002_lamping
lapsing103511162_lapsing
lapwing13308262_lapwing
lipping123016072_lipping
lopping123815222_lopping
mapping143413992_mapping
napping123514182_napping
plopping12318702plopping
rapping123619102_rapping
sapping123519312_sapping
scrapping1635742scrapping
slipping133510662slipping
slopping133811422slopping
snapping13349652snapping
swapping16348672swapping
tapping123317132_tapping
trapping132911392trapping
wapping153514602_wapping
whapping19317112whapping
wrapping16297622wrapping
yapping153412612_yapping
zapping213211472_zapping
adapting1236643adapting
alarming1138583alarming
amping114317573__amping
aping87327233__a_ping
becapping1834243becapping
beclasping17134073beclasping
blabbing12266723blabbing
blacking174213603blacking
blading113615363bla_ding
blagging13319163blagging
blaming123515693bla_ming
blanking154411933blanking
blaring104317113bla_ring
blasting114013433blasting
blatting114111653blatting
blawing134012753bla_wing
blazing193612393bla_zing
bleeping13377933bleeping
blooping13248843blooping
bopping143512033_bopping
cabbing143613153c_abbing
cabling124017553c_abling
caching156317503c_aching
cadging123610973c_adging
caging105321023c_a_ging
caking134624673c_a_king
calking144617783c_alking
calling103826773c_alling
calming123915973c_alming
calpain11310413calpain_
calpains1239763calpains
calquing2035593calquing
calving134113503c_alving
campings154010203c_ampings
campong14318123c_ampong
caning94128623c_a_ning
canning103620133c_anning
canting104725903c_anting
capering132414963c_apering
caplin103216303c_aplin_
caplins113515993c_aplins
caprine11314233c_aprine
carding113922433c_arding
caring95137993c_a_ring
carking144322853c_arking
carling103727063c_arling
carpings133812383c_arpings
carting104228283c_arting
carving133916773c_arving
cashing135022553c_ashing
casing94829103c_a_sing
casking144317353c_asking
casting104628343c_asting
catling104819793c_atling
catnapping1742533catnapping
catting103922643c_atting
causing103614413c_ausing
caving124822613c_a_ving
cawing124322613c_a_wing
ceasing104118263cea_sing
chaffing2036323chaffing
chafing163911493cha_fing
chaining142810783chaining
chairing143110773chairing
chalking183310063chalking
chancing162810283chancing
changing153211513changing
chanting143413533chanting
chappie16298653chappi_e
chappies172610093chappies
charging152910773charging
charing133721323cha_ring
charking183512613charking
charming163012033charming
charring142913163charring
charting142614193charting
chasing133715893cha_sing
chatting142810143chatting
chawing164813033cha_wing
cheeping16329553cheeping
chirping16278863chirping
chomping18339883chomping
chumping18349063chumping
cioppino1443343cioppino
claddings1433213claddings
clamoring1477423clamoring
clang86019313cla___ng
clapped143511173clapp_ed
clapper134011863clapp_er
clappers143310833clappers
clavering1538373clavering
claypan1434313claypan_
claypans1543873claypans
cleaning113112383cleaning
cleansing1235073cleansing
clearing113014883clearing
clearwing1533673clearwing
cleating113518133cleating
cleaving141389683cleaving
cleeking15267813cleeking
clefting14347583clefting
clerking15257163clerking
clewing13359583cl_ewing
clicking173610983clicking
climbing15205983climbing
cling86424673cl___ing
clinging122910913clinging
clinking153611663clinking
cliquing2035363cliquing
cloaking15299713cloaking
clocking174312413clocking
clogging13368503clogging
cloning103215473cl_oning
clonking153810153clonking
closing103114843cl_osing
clothing14278783clothing
clotting113110643clotting
clouding12269493clouding
clouring112811273clouring
clouting113011683clouting
clowning14307253clowning
cloying133511753cl_oying
clubbing15266513clubbing
clucking17429993clucking
clueing104110093cl_ueing
cluing93913503cl__uing
clunking15329433clunking
coaching164011963coaching
coacting133412703coacting
coaling103722823coa_ling
coaming123818323coa_ming
coasting113615513coasting
coating103525313coa_ting
coaxing173511703coa_xing
collapsing1543823collapsing
comping143518593c_omping
compting153013603compting
cooping123918933c_ooping
coopting133411313coopting
coping113927663c__oping
copying153411983c_opying
couping124317023c_ouping
coupling13310783coupling
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
crafting143710173crafting
cramming15339433cramming
craning103620303cra_ning
cranking154613073cranking
crappie13298983crappi_e
crappier14288133crappier
crappies142911153crappies
crashing143512633crashing
crating103725203cra_ting
craving134015733cra_ving
crawling143110513crawling
crazing193914583cra_zing
creeping133310103creeping
creping122913653c_reping
crimping15299783crimping
crippling1644093crippling
crisping13319663crisping
crumping15319903crumping
cuppings15336053c_uppings
damping133414003_damping
dappling1436843_dappling
dipping134014833_dipping
draping114213353dra_ping
dripping14278033dripping
dropping14309283dropping
dupping133711043_dupping
eclipsing1443743eclipsing
elaphine1346113elaphine
elapine9310673ela_pine
elating83423083ela_ting
eloping103512833el_oping
enclasping1544103enclasping
flacking184311793flacking
flagging14329223flagging
flailing12298923flailing
flaking154114493fla_king
flaming134216443fla_ming
flamming16357153flamming
flanging132710583flanging
flanking164211083flanking
flappier1544293flappier
flaring114116803fla_ring
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
flawing143812563fla_wing
flaying143914463fla_ying
flumping16287583flumping
fopping153511133_fopping
galoping1258023galoping
gaping105618923_ga_ping
gasping113714363_gasping
gawping14418463_gawping
gipping133813123_gipping
glaceing1236533glaceing
gladding1236303gladding
glairing1047283glairing
glancing1247063glancing
glaring93714883gla_ring
glassing10329973glassing
glazing183611003gla_zing
graphing1538533graphing
grappling1544993grappling
grasping12348833grasping
gripping14277543gripping
gypping16305843_gypping
harping134118383_harping
hasping134414903_hasping
heaping133015853hea_ping
hipping153915103_hipping
hopping154115273_hopping
inclasping1543803inclasping
inclipping1742903inclipping
japing165013573_ja_ping
jauping17307193_jauping
kepping16268593_kepping
kipping163311873_kipping
lacing94626233_la_cing
lacking143821543_lacking
lading84227123_la_ding
ladling92813393_ladling
lagging103316733_lagging
lairing83715343_lairing
laking115027043_la_king
lalling83519623_lalling
lambing123412413_lambing
laming94528363_la_ming
lamming123014583_lamming
lancing103314123_lancing
landing92819323_landing
lapin75222923_la_pin_
lapins84520683_la_pins
lappering14258843_lappering
lapwings14274973_lapwings
larding92917873_larding
larking123718253_larking
lashing114422893_lashing
lasing74727983_la_sing
lasting84725243_lasting
lathing114315693_lathing
lauding93211903_lauding
laving104623573_la_ving
lawing104625283_la_wing
laying104525703_la_ying
lazing164821473_la_zing
lazying2046673_lazying
leaping103215993_leaping
limping124614113_limping
lippings13296093_lippings
lisping103412753_lisping
looping103615283_looping
loping93921413_l_oping
louping104313983_louping
lumping123314643_lumping
mappings15296413_mappings
mopping143411473_mopping
nipping123412873_nipping
palping124112873_palping
pepping113511623_pepping
pipping113414743_pipping
placing123815283pla_cing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pla_ning
planking153513013planking
planning113610223planning
planting113515383planting
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
plumping15277633plumping
popping113715413_popping
prepping12309763prepping
propping122811673propping
pupping114412503_pupping
quipping2234843quipping
ralphing1435413ralphing
ramping123316873_ramping
raping94829853_ra_ping
rappini11347573_rappini
rasping104316253_rasping
reaping103621213rea_ping
recapping1636453recapping
reclasping15105083reclasping
relapsing1236843relapsing
remapping1635023remapping
repping123314983_repping
ripping123315743_ripping
sapling103217863_sapling
scalping133410453scalping
scamping153510193scamping
scaping123715693sca_ping
scarping133312463scarping
schlepping2041743schlepping
sclaffing1843363sclaffing
scraping133310863scra_ping
shaping133116183sha_ping
sharping143011373sharping
shipping163611253shipping
shlepping1733393shlepping
shopping163611293shopping
sipping123117433_sipping
skipping17297603skipping
slabbing13287783slabbing
slacking153914133slacking
slagging113711573slagging
slaking123717473sla_king
slamming133310003slamming
slanging103413433slanging
slanting94115093slanting
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
sleeping113812053sleeping
sliping103314413sl_iping
sloping104114073sl_oping
slumping13359973slumping
slurping11278123slurping
snipping13308853snipping
soaping103616223soa_ping
sopping123917203_sopping
stamping133310963stamping
stapling112813153stapling
stepping13329073stepping
stopping133611413stopping
strapping1436993strapping
supping123814533_supping
swamping16307923swamping
swopping16377963swopping
tamping122815813_tamping
taping94222393_ta_ping
tappings13267713_tappings
tipping122814973_tipping
topping123514623_topping
tramping132711273tramping
trappings14265753trappings
tripping133210923tripping
tupping123411663_tupping
uncapping1635133uncapping
unclamping1743433unclamping
unclasping1544123unclasping
unclipping1743313unclipping
upping114013703__upping
vamping152810233_vamping
warping133715183_warping
whipping19328173whipping
whopping19357373whopping
whupping19345243whupping
wrappings17253713wrappings
yauping13357243_yauping
yawping16357333_yawping
yipping152710683_yipping
zipping212910573_zipping

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 Limit1461624347.06320694.0
3Display Results4344340.1702552.9
 (SQL Overall)1786914347.63923391.9
 
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.