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

145 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
rivetting1325641(None) 
revetting132912631revetting
riveting12139441rive_ting
brevetting1644332brevetting
diverting142410332diverting
divesting14298482divesting
pipetting1435512pipetting
reletting102713942reletting
resetting102816292resetting
retting83425882r__etting
reverting132315132reverting
revesting132814122revesting
rewetting132710442rewetting
vetting114216562__vetting
abetting1158293_abetting
advecting1645113advecting
adverting1437223adverting
averting122512733_averting
begetting13186583begetting
besetting12268423besetting
betting103921403__betting
bisecting1436973bisecting
bitting103717293bi__tting
breveting1536263breve_ting
briquetting2351743briquetting
caveating1539293caveating
coveting141912313cove_ting
curetting1236573curetting
curvetting1643393curvetting
devesting14249903devesting
dieting93616833di_e_ting
digesting12208673digesting
dipnetting1453623dipnetting
directing1338823directing
diverging15226693diverging
driveling1445763drive_ling
drivelling1543983drivelling
duetting1047183_duetting
everting122213133_everting
facetting1535283facetting
fetting113517873__fetting
fileting1239303file_ting
fitting113516563fi__tting
fretting122711523_fretting
fritting123510703fri__tting
gavotting1443193gavotting
gazetting2043243gazetting
getting93316563__getting
gibbetting1642313gibbetting
gitting93215703gi__tting
gritting10309983gri__tting
hitting113017273hi__tting
ideating10311703_ideating
inletting1087873inletting
insetting1079283insetting
inventing13109973inventing
inverting131013223inverting
investing13119393investing
jetting153815343__jetting
kitting123214443ki__tting
letting83218533__letting
livening12248153live_ning
livering122012383live_ring
miseating121215433miseating
missetting13107903missetting
netting84018763__netting
obverting1536303obverting
orienting1038723ori_enting
petting103720953__petting
pitting103618873pi__tting
pivoting1436183piv_oting
presetting131010833presetting
preventing161210263preventing
priesting1239483pri_esting
ratting83822363r__atting
raveling123414373rave_ling
ravelling13269253ravelling
ravening122611293rave_ning
rebutting1237523rebutting
recutting1239483recutting
reesting93118273r_eesting
refecting152413353refecting
refitting132811123refitting
regretting1237783regretting
reheating132314913reheating
reinventing1545253reinventing
reinvesting1545323reinvesting
rejecting192211153rejecting
relenting102716773relenting
remeeting12311433remeeting
remelting12311703remelting
remitting122412623remitting
renesting102514703renesting
renting84026853r__enting
repeating122618983repeating
repenting122316553repenting
repotting12511123repotting
rerenting102617663rerenting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resettling1135893resettling
resitting103414873resitting
resting85031183r__esting
retesting102614603retesting
retying113213833r__etying
revealing132611883revealing
reveling123117083reve_ling
revelling132412553revelling
revenging1438083revenging
reverbing15248593reverbing
revering122918073reve_ring
reversing132611483reversing
revolting1339633revolting
revoting12312033rev_oting
riesling939013ri_esling
rifting113515003ri__fting
righting132610853ri_ghting
rioting82716393ri__oting
ripening1138573ripe_ning
riposting1236063riposting
rivaling1239913riv_aling
rivalling1335963rivalling
riverine11310803rive_rine
rivetingly1743553rive_tingly
rivetted12226093rivett_ed
riving104521423riv___ing
rotting82919683r__otting
rouletting1144753rouletting
russetting1184253russetting
rutting82718043r__utting
setting83621393__setting
sitting83519633si__tting
stetting93410713_stetting
trisecting1345503trisecting
unsetting1088993unsetting
upsetting1275563upsetting
vatting113614853__vatting
venting114218093__venting
vesting114618683__vesting
vetoing11309053__vetoing
vignetting1542823vignetting
wetting114117383__wetting
whetting1535973_whetting
witting113417063wi__tting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411457.47019898.4
3Display Results1451450.0801812.5
 (SQL Overall)1786911457.97022420.5
 
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.