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

185 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
caverned143616(None) 
averred11237592_averred
averted112211612_averted
cabernet12410762cabernet
cairned1037642ca_irned
capered123014042caper_ed
careened1139192careened
caserne93710062caserne_
casernes103810752casernes
catered103117782cater_ed
caveated1439132caveated
cavern115312452cavern__
caverns124510252cavern_s
cavorted1435692cavorted
cayenned1443162cayenned
clavered14187632claver_ed
covered133315292cover_ed
cravened1476722crave_ned
davened124610072dave_ned
governed1335192governed
havened14429242have_ned
havered144011452haver_ed
ravened115012282rave_ned
taverner1134422taverner
wavered142910432waver_ed
acorned10238283_acorned
adorned9256893_adorned
adverted1336103adverted
aeried74221873_a_eried
alerted82512223_alerted
amerced1256523_amerced
avenged1245503_avenged
averaged1356223_averaged
averse95811183_averse_
averter102410553_averter
barned95623583ba__rned
beavered1437503beaver_ed
cabernets1345063cabernets
cabined1239993ca_bined
cadenced1435523cadenced
caftaned1445093caftaned
calcined1338743calcined
cambered15129003camber_ed
cameoed1238383came_oed
camerae11312063camerae_
cancered132411553cancer_ed
caned85838093ca___ned
cankered153010223canker_ed
canned95022063ca__nned
cannoned11118143cannoned
cantered113415993canter_ed
cantoned111411523cantoned
caperer113013403caper_er
carded105424903ca__rded
cared86050093ca__r_ed
careener1039333careener
careered1139503careered
caressed1139173caressed
caried94528693ca__ried
carked134024823ca__rked
carnet84732873ca__rnet
carney115315703ca__rney
carped115923763ca__rped
carried103717153ca_rried
carted98631443ca__rted
cartoned111312833cartoned
carved124320853ca__rved
caseated11310713caseated
casefied1445943casefied
casern84713313casern__
caserns94711223casern_s
caterer92815953cater_er
caved116227563cav___ed
cavemen1437143cave_men
caver105629063caver___
caverning1536283caverning
cavernous1444563cavernous
cavers115026843caver__s
caviled1348723cav_iled
cavilled1436733cavilled
cavitied14126813cavitied
cavorter1335783cavorter
cayenne1244603cayenne_
cayennes1345013cayennes
cered85227443c__er_ed
chaperoned1843873chaperoned
cheered133713303cheer_ed
cheerled14105713cheerled
churned13358373c_hurned
cleaned103512003c_leaned
clerked14326653c_lerked
clovered14187363clover_ed
coerced1238583c_oerced
cohered133514693coher_ed
concerned1438643concerned
convened143412223conve_ned
converged1636973converged
conversed1538683conversed
converted15311563converted
corned95224523c__orned
covaried1448003covaried
coverer123113523cover_er
coverlet13413013coverlet
coverlid1445943coverlid
coveted133011523cove_ted
cowered133214653cower_ed
cozened19349183coze_ned
cratered1149693crater_ed
darned85018483da__rned
decerned1237263decerned
deveined1336673deveined
diverged14256883diverged
diverted13199583diverted
dovened12389063dove_ned
earned74818333ea__rned
evened101010313_eve_ned
everted112711853_everted
favored1455983favor_ed
fevered14339723fever_ed
gaveled12399133gave_led
gavelled13387363gavelled
haverel13397153haver_el
hovered143411573hover_ed
interned93016653interned
inversed12269283inversed
inverted122312163inverted
javelined2043323javelined
kerned114112933__kerned
ladened979053lade_ned
lagered92311153lager_ed
latened8711923late_ned
laveered1235253laveered
layered11259413layer_ed
leavened1235553leave_ned
levered114212303lever_ed
livened11238933live_ned
livered113111633liver_ed
liveried1238733liveried
obverted1435103obverted
overbed132811853_overbed
overed102216623_over_ed
overfed142510253_overfed
overnew13268133_overnew
papered122513173paper_ed
patterned1265753patterned
paveed12438893pave__ed
quavered2144823quaver_ed
raveled114113633rave_led
ravelled12419783ravelled
ravener104110743rave_ner
ravined115411823rav_ined
reverbed14269223reverbed
revered112819333rever_ed
reverend12288853reverend
reversed122711613reversed
reverted122714713reverted
riverbed14245143riverbed
sabered103213023saber_ed
savored1158343savor_ed
scavenged1642153scavenged
secerned1136103secerned
severed113513863sever_ed
slavered12188033slaver_ed
tabered103311593taber_ed
tapered102612933taper_ed
tavern9428933tavern__
taverna10285383tavern_a
tavernas11365043tavernas
taverners1244273taverners
taverns10317803tavern_s
traversed1344573traversed
unaverted1336563unaverted
unveined1258003unveined
unversed122310443unversed
veined104413913__veined
verged114815163__verged
versed104515523__versed
wafered14288433wafer_ed
wagered12299333wager_ed
wakened1546873wake_ned
warned104018913wa__rned
waterbed1436453waterbed
watered113014963water_ed
waverer13319523waver_er
yarned105514023ya__rned

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621857.79618748.3
3Display Results1851850.0762434.2
 (SQL Overall)1786911858.29521542.0
 
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.