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

452 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
capering13241497(None) 
catering112019921catering
papering132213311papering
tapering112112501tapering
cageling12310852cageling
calipering1545002calipering
cambering16109872cambering
cameoing1379072cameoing
cankering162110792cankering
cantering122417382cantering
capelin11510972capelin_
capelins12311132capelins
capping143819672cap_ping
caprine11314232cap_rine
capturing1436622capturing
careering12311202careering
caring95137992ca__ring
carpeting1439482carpeting
caverning1536292caverning
cering94522542c__ering
chaptering18107962chaptering
cheering143612712cheering
ciphering17217702ciphering
clavering1538372clavering
cohering142413852cohering
compering163414172compering
coopering142611332coopering
coppering162810902coppering
covering142215742covering
cowering142514052cowering
cratering12312652cratering
cupeling1338872cupeling
cyphering20175242cyphering
diapering1339032diapering
hampering1738862hampering
havering152211052havering
lagering102212312lagering
lappering14258842lappering
layering122310352layering
pampering1638382pampering
paupering1437272paupering
sabering112113742sabering
scampering1745322scampering
scarpering1545412scarpering
supering11317682supering
tabering112211422tabering
tampering1438452tampering
vaporing1437652vaporing
wafering15208892wafering
wagering13219522wagering
watering122316322watering
wavering152410542wavering
acceding1446093acceding
adhering1338883adhering
adoring9412523_adoring
ageing84213403_age_ing
airing74927503_a_iring
alerting91312383_alerting
altering91917123altering
amercing1337193_amercing
anearing9413973_anearing
aneling82719503_aneling
angering102113803angering
aperient10715153_aperient
aperies9423203_aperies
aping87327233_ap__ing
appearing1436893appearing
aspersing1237603aspersing
aspiring1138873aspiring
averring12239063_averring
averting122512733_averting
aweing103911253_awe_ing
badgering1436973badgering
bannering12208813bannering
bantering122414243bantering
barbering14229693barbering
baring95135853ba__ring
barring104021593ba_rring
bartering122313653bartering
battering122715153battering
beavering1538703beavering
bowering142911723bowering
bumpering1636593bumpering
cabbing143613153ca_bbing
cabining1338653cabining
cabling124017553ca_bling
cacheting1737153cacheting
caching156317503ca_ching
cackling172610943cackling
caddying16225063caddying
cadencing1544973cadencing
cadging123610973ca_dging
cagelings1335423cagelings
caging105321023ca__ging
cajoling18318423cajoling
caking134624673ca__king
calking144617783ca_lking
calling103826773ca_lling
callipering1652913callipering
calming123915973ca_lming
calquing2035593calquing
calving134113503ca_lving
campesino1544633campesino
camping143118973ca_mping
campusing1654913campusing
canaling112016413canaling
canceling14310163canceling
candling122313873candling
candying15188993candying
caning94128633ca__ning
canning103620143ca_nning
canoeing11310213canoeing
canting104725903ca_nting
capelan1139013capelan_
capelans1238013capelans
capellini1345283capellini
caper94831623caper___
capered123014043caper_ed
caperer113013403caper_er
caperers122611723caperers
capers105428143caper__s
capeskin1644403capeskin_
capeskins1744073capeskins
caplin103216303cap_lin_
caplins113515993cap_lins
cappings15369493cap_pings
capric12411803cap_ri_c
caprice1349683cap_rice
caprifig1643223cap_rifig
capris10415083cap_ri_s
capsizing2345833capsizing
capsuling1444543capsuling
captain112111063captain_
captains121810573captains
carding113922443ca_rding
careening12310023careening
caressing1238803caressing
carina84325333ca__rina
carking144322853ca_rking
carling103727073ca_rling
caroling113317003caroling
caroming133312963caroming
carpetings1544213carpetings
carping123521083ca_rping
carrying14148373carrying
carting104228283ca_rting
carving133916773ca_rving
caseating12311743caseating
casefying1843753casefying
casein83216453case_in_
caseins93115053case_ins
casern84713313caser_n_
caserne93710063caser_ne
caserns94711223caser_ns
cashiering1643783cashiering
cashing135022553ca_shing
casing94829103ca__sing
casketing1635383casketing
casking144317353ca_sking
casting104628343ca_sting
castling11311233castling
catching163712773catching
cateran9313773cateran_
caterans10313223caterans
catling104819793ca_tling
catting103922643ca_tting
caulking1536803caulking
causing103614413ca_using
caveating1539293caveating
cavern115312453caver_n_
caverns124510253caver_ns
caviling14310113caviling
caving124822613ca__ving
cavorting1536063cavorting
cawing124322613ca__wing
ceding104014813c__eding
centering122915143centering
centring112112953centring
chaffering22104643chaffering
chairing143110773chairing
chambering20116043chambering
chamfering21125333chamfering
chaperon1547353chaperon_
chaperone1646563chaperone
chaperoning1952633chaperoning
chaperons1646893chaperons
chapping183710723chap_ping
charing133721323c_haring
charring142913163charring
chartering16109253chartering
chattering16108643chattering
cheapening1883803cheapening
cheeking18349093cheeking
cheeping16329563cheeping
cheesing14349423cheesing
chefing16359043c_hefing
chewing163911153c_hewing
chippering2045163chippering
chirring142610173chirring
choiring14279793choiring
choppering2064813choppering
choring133617663c_horing
churring14298653churring
cindering13311223cindering
cinerin9313823cinerin_
cinerins10414103cinerins
clabbering17104583clabbering
clambering1776163clambering
clamoring1477423clamoring
clapping153810603clap_ping
clattering13109233clattering
clearing113014883clearing
cleeking15267823cleeking
cleping123310433c_leping
clerking15257163c_lerking
clewing13359593c_lewing
clouring112811273clouring
clueing104110103clue_ing
coappearing1842763coappearing
coapting133511623coap_ting
cockering1839703cockering
coercing1349013c_oercing
coffering1838053coffering
coloring11414853coloring
comparing162410583comparing
compeering1747053compeering
competing163712473competing
cooeeing1137473cooeeing
cooeying1438163cooeying
coping113927673cop__ing
copping143918603cop_ping
copying153411993cop_ying
coring94433973c__oring
cornering12311903cornering
coshering15510033coshering
coverings15217913coverings
coveting141912323coveting
cozening20188333cozening
craping124018713crap__ing
crapping153911453crap_ping
craterings1346003craterings
cravening1547563cravening
creeling113513373creeling
creeping133310113creeping
creping122913663c_reping
crewing133212643c_rewing
cueing94913623c_ue_ing
cumbering16108203cumbering
cupelling1436283cupelling
cupping144312383cup_ping
curing94824783c__uring
curring103616843c_urring
dackering1737393dackering
daggering13246113daggering
daikering1536103daikering
dampening1535463dampening
dandering122511063dandering
dangering12239303dangering
dapping133714793dap_ping
dappling1436843dappling
daring84928683da__ring
davening13258883davening
deperming1537113deperming
dowering132510623dowering
earing75235483ea__ring
earring83519013ea_rring
entering91920053entering
experting1938053experting
expiring1836253expiring
faceting1438783faceting
fairing113614013fa_iring
faltering132211123faltering
faring105231283fa__ring
fathering161010093fathering
favoring1596673favoring
fevering152510083fevering
fleering123811283fleering
gaeing84617223ga_e_ing
gandering122111293gandering
gaping105618923gap__ing
gapping134214783gap_ping
garnering11298093garnering
garring93116713ga_rring
gartering112111593gartering
gathering1499463gathering
gaveling133410163gaveling
haeing104118923ha_e_ing
haltering132212013haltering
hammering1737633hammering
hankering17239383hankering
happening1735593happening
happing153817233hap_ping
haring104233003ha__ring
havening15258563havening
homering141512083homering
hovering151911153hovering
impeding1436563impeding
inhering12913713inhering
jabbering2134443jabbering
japeries17311463japeries
japing165013573jap__ing
jarring153613193ja_rring
jeering153513043_jeering
kashering1736253kashering
kippering18205443kippering
laagering1136833laagering
labeling11311653labeling
laboring112110143laboring
lacewing1435843lacewing
lackering1639383lackering
laddering1237593laddering
ladening1078833ladening
lairing83715343la_iring
lapping124117023lap_ping
lapsing103511163lap_sing
lapwing13308263lap_wing
latening9711503latening
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layerings13235683layerings
leering83417643_leering
levering122212503levering
lippering14217883lippering
livering122012383livering
loppering14237283loppering
lowering122210923lowering
majoring1836363majoring
mammering1337333mammering
manuring1139223manuring
mapping143413993map_ping
marring103319563ma_rring
mastering122315313mastering
mattering122314063mattering
maturing1139963maturing
metering112915633metering
mitering113015403mitering
naperies10313903naperies
napping123514183nap_ping
nattering102212223nattering
nidering10510483nidering
oaring74225303oa__ring
ochering14219403ochering
offering1536393offering
opening1039943_opening
ordering1039353ordering
outcapering1643333outcapering
overing111918063_overing
pairing103716733pa_iring
paltering122612903paltering
pandering133211963pandering
paneling111013633paneling
papyrine1546053papyrine
paring94236493__paring
parring103222063pa_rring
pattering122314433pattering
peeing94618083__peeing
peering103520353_peering
peppering1337083peppering
perking143716463__perking
perming123416093__perming
petering112516813petering
piperine122011833piperine
poring94227273__poring
powering142210813powering
quavering2235953quavering
queering1838203queering
raping94829853rap__ing
rappeling1435963rappeling
rapping123619103rap_ping
rapturing1245363rapturing
raring74332873ra__ring
raveling123414373raveling
ravening122611303ravening
razeeing1834373razeeing
razoring1836443razoring
repapering1547043repapering
reperking1638703reperking
revering122918073revering
ripening1138583ripening
rogering10310283rogering
sabeing102611863sabe_ing
sabring102614843sa_bring
sacring103115983sa_cring
saggering12197793saggering
sapling103217863sap_ling
sapping123519313sap_ping
savoring1269483savoring
scaping123715693scap__ing
scaring103421973sca__ring
scarring112511513sca_rring
scattering1398013scattering
sceptering1545793sceptering
sceptring1444273sceptring
scuppering1754023scuppering
sering74731813__sering
severing122013853severing
sewering122411093sewering
sheering123715103sheering
simpering1449293simpering
slavering1338723slavering
sneering93414503sneering
sobering111912793sobering
spaeing103413543spae_ing
sparing104823873_sparing
sparring113112223sparring
spearing113216103_spearing
speering113116323speering
speiring113711263_speiring
spewing133110453_spewing
sphering142811943sphering
spiering112713353spiering
spiring103918183_spiring
sporing104319413_sporing
spring94526013_sp_ring
steering93916793steering
syphering18175733syphering
taboring113010193taboring
tapeline10310363tapeline
taping94222393tap__ing
tapping123317133tap_ping
taring73932283ta__ring
tarring83318303ta_rring
tattering102212333tattering
tempering1438733tempering
tiering8315253_tiering
towering122610883towering
trapesing1247263trapesing
ulcering1139333ulcering
umbering1399433umbering
umpiring1336093umpiring
ushering1258923ushering
uttering91613083uttering
valeting1238853valeting
vaporings1544093vaporings
vapouring1544653vapouring
veering113213683_veering
viperine13189713viperine
wairing113414313wa_iring
waitering13310723waitering
wakening1636333wakening
wandering143310983wandering
wapping153514603wap_ping
waring105029443wa__ring
warring113717973wa_rring
waterings13229263waterings
yabbering1734023yabbering
yammering1735193yammering
yapping153412613yap_ping
yattering132410453yattering
zapping213211473zap_ping
zippering23215203zippering

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.420425454.8
2DLD Change Limit1461624527.18620339.8
3Display Results4524520.1902378.9
 (SQL Overall)1786914527.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.