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

139 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
caverning153628(None) 
averring12239062_averring
averting122512732_averting
capering132414962caper_ing
careening12310012careening
catering112019912cater_ing
caveating1539292caveating
cavorting1536062cavorting
clavering1538372claver_ing
covering142215732cover_ing
cravening1547552crave_ning
davening13258872dave_ning
governing1435532governing
havening15258552have_ning
havering152211052haver_ing
ravening122611292rave_ning
wavering152410542waver_ing
aborning1188003_aborning
adorning1087323_adorning
adverting1437223adverting
alerting91312383_alerting
amercing1337193_amercing
avenging1345863_avenging
averaging1446503_averaging
barning104320353ba__rning
beavering1538703beaver_ing
cabining1338643ca_bining
cadencing1544963cadencing
cageling12310843cage_ling
calcining1447813calcining
cambering16109873camber_ing
cameoing1379063came_oing
caning94128623ca___ning
cankering162110793canker_ing
canning103620133ca__nning
cannoning1237323cannoning
cantering122417383canter_ing
cantoning12310883cantoning
canyoning1536873canyoning
carding113922443ca__rding
careering12311203careering
caressing1238803caressing
caring95137993ca__r_ing
carking144322853ca__rking
carling103727063ca__rling
carping123521083ca__rping
carrying14148373ca_rrying
carting104228283ca__rting
cartoning12311113cartoning
carving133916773ca__rving
caseating12311743caseating
casefying1843753casefying
cavern115312453caver__n_
caverned1436163cavern_ed
cavernous1444563cavernous
caverns124510253caver__ns
caviling14310113cav_iling
cavilling1536393cavilling
caving124822613cav___ing
cering94522533c__er_ing
chaperoning1952633chaperoning
cheering143612703cheer_ing
churning14237173c_hurning
cleaning113112383c_leaning
clerking15257163c_lerking
coercing1349003c_oercing
cohering142413843coher_ing
concerning1548903concerning
convening15311203conve_ning
converging1758093converging
conversing16310543conversing
converting16313133converting
corning103720133c__orning
covarying1844133covarying
coverings15217903cover_ings
coversine1459703coversine
coveting141912313cove_ting
cowering142514043cower_ing
cozening20188323coze_ning
cratering12312653crater_ing
darning93817333da__rning
decerning1337293decerning
deveining1436393deveining
diverging15226693diverging
diverting142410333diverting
dovening13238363dove_ning
earning83418213ea__rning
evening11310223_eve_ning
everting122213133_everting
favoring1596673favor_ing
fevering152510083fever_ing
gaveling133410163gave_ling
gavelling14286893gavelling
hovering151911143hover_ing
interning10315253interning
inversing1389623inversing
inverting131013223inverting
javelining2142513javelining
kerning124010893__kerning
ladening1078823lade_ning
lagering102212313lager_ing
latening9711493late_ning
laveering1336813laveering
layering122310353layer_ing
leavening1365973leave_ning
levering122212503lever_ing
livening12248153live_ning
livering122012383liver_ing
obverting1536303obverting
overing111918053_over_ing
papering132213313paper_ing
patterning1346073patterning
quavering2235953quaver_ing
raveling123414373rave_ling
ravelling13269263ravelling
ravenings13235183rave_nings
ravining12269693rav_ining
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
sabering112113743saber_ing
savoring1269483savor_ing
scavenging1742073scavenging
secerning1246203secerning
severing122013853sever_ing
slavering1338723slaver_ing
tabering112211423taber_ing
tapering112112503taper_ing
traversing1444803traversing
veining114713893__veining
verging123812303__verging
versing112314193__versing
wafering15208893wafer_ing
wagering13219523wager_ing
wakening1636323wake_ning
warning113717093wa__rning
watering122316323water_ing
yarning113512953ya__rning

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411396.40323214.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.88925938.6
 
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.