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

211 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
ravelin10221102(None) 
javelin17306981javelin
raveling123414371raveling
ravelins113011601ravelins
capelin11510972capelin
gaveling133410162gaveling
graveling1457382graveling
javelina18315452javelina
javelins18277732javelins
ramekin13126492ramekin
ratlin64116522ra_tlin
ravel84621512ravel__
raveled114113632raveled
raveler104212462raveler
ravelings13377382ravelings
ravelling13269242ravelling
ravelly13268352ravelly
ravels94717072ravel_s
raven84723442rave__n
ravening122611292ravening
ravin85624652rav__in
reveling123117082reveling
traveling1349052traveling
abelia83114403_abelia
abelian92810643_abelian
acetin8314693_acetin
alevin92511513_alevin
alexin132311483_alexin
aneling82719503_aneling
anilin6417793_anilin
atelic8313703_atelic
avellan1037293_avellan
avidin103510843_avidin
baseline10310753baseline
beveling143011033beveling
brasilin1046963brasilin
bravely15428233bravel_y
brazilin1944383brazilin
bromelin1246343bromelin
cageling12310843cageling
camelia11510433camelia
camelid1249413camelid
capelan1139003capelan
capelins12311133capelins
caplin103216303ca_plin
carlin84421823ca_rlin
casein83216453case_in
catlin83819083ca_tlin
cavelike1738213cavelike
caveman1437073caveman
cavemen1437143cavemen
cavern115312453cave_rn
caviling14310113caviling
craven114113933crave__n
cravening1547553cravening
dateline9810353dateline
daven94916473dave__n
davening13258873davening
devein1039143deve_in
develing133212733develing
driveline1345353driveline
driveling1445763driveling
fadein1068843fade_in
favela1237033favel_a
favelas1337023favelas
favella1336173favella
franklin15104603franklin
fraulein1142983fraulein
gallein8299043gallein
gamelan10106643gamelan
gavel95815183gavel__
gaveled12399133gaveled
gavelkind18132153gavelkind
gavelling14286873gavelling
gavels105911093gavel_s
graplin1058443gra_plin
gravel105313823gravel__
graveled13417363graveled
gravelike1744513gravelike
gravelling1565213gravelling
gravelly15385773gravelly
gravels113611143gravel_s
gravely14469063gravel_y
graven104513523grave__n
groveling1435573groveling
haemin113412663ha_emin
harelip1245953harelip
haven114718533have__n
havening15258553havening
havering152211053havering
hoveling15189593hoveling
javelinas19353583javelinas
javelined2043323javelined
kaolin1039583ka_olin
labeling11311643labeling
lanolin7310643lanolin
leveling122910433leveling
levulin1044663levulin
marlin84220903ma_rlin
marveling1537103marveling
maudlin1037163maudlin
maven104816893mave__n
mavin105722953mav__in
myelin1138973_myelin
navel87016573navel__
navels95712693navel_s
paneling111013623paneling
parvolin1376933parvolin
paulin8312983pa_ulin
pavilion1344903pavilion
pavin105623203pav__in
rabbin103112303ra_bbin
rabbling13239333rabbling
racemic1336983racemic
raddling11229773raddling
raffling1567063raffling
raglan73711503ra_glan
railing83325643ra_iling
rain46251733ra___in
raisin62716923ra_isin
ralline73518413ra_lline
rambling131810773rambling
ramekins1466113ramekins
ramen75625193rame__n
ramequin1942813ramequin
ramilie9310283ramilie
rankling132610113rankling
rappeling1435963rappeling
rarebit948423rarebit
rarely93513653rarel_y
rassling939013rassling
ratel54224883ratel__
ratels64518213ratel_s
ratline74517803ra_tline
ratlins73615583ra_tlins
rattling92510873rattling
ravaging1346323ravaging
rave75542093rave___
raved94931433rave__d
ravelers113310863ravelers
ravelled12419783ravelled
raveller11339263raveller
ravellings14214453ravellings
ravelment1447203ravelment
ravened115012283ravened
ravener104110733ravener
ravenings13235183ravenings
ravenlike16103863ravenlike
ravens93916883rave_ns
raver85631493rave__r
ravers94628183rave_rs
raves85441973rave__s
ravine95522223rav__ine
raving105128853rav__ing
ravining12269693ravining
ravins94622563rav__ins
ravioli1055613ravioli_
raviolis1146103raviolis
rawin85521473ra__win
razeeing1834363razeeing
rebegin1036213rebegin
reeling83126863r_eeling
rein46040893r__e_in
relic74623363r__elic
reline65434353r__eline
relink104415923r__elink
relit55340683r__elit
renin54830033r__enin
repin75324703r__epin
resilin72913973resilin
resin54131053r__esin
revealing132611883revealing
revel84423163revel__
reveled113917753reveled
reveler104116343reveler
revelling132412553revelling
revelry1335693revelry
revels94220573revel_s
reverie103615163reverie
revering122918073revering
reviling122917213reviling
rewin85623963r__ewin
rivaling1239913rivaling
riven85121623rive__n
riverine11310803riverine
riveting12139443riveting
roven85521973rove__n
roweling122811123roweling
savarin10310003savarin
saveloy1334663saveloy
savin84625083sav__in
shaveling1646843shaveling
tamein8313093tame_in
tapeline10310363tapeline
tavern9428933tave_rn
theelin1038003theelin
trameling1249053trameling
travel94112983travel__
traveled12349453traveled
traveler11328433traveler
travelling1456533travelling
travelog1243513travelog
travels104711293travel_s
unraveling1454473unraveling
vaseline1138613vaseline
vein75625753__ve_in
venin85118663__venin
wavelet13310943wavelet
wavelike1836613wavelike
wavering152410543wavering
yeelin939343_yeelin

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272115.98322401.3
3Display Results2112110.0802637.5
 (SQL Overall)1786912116.20328807.2
 
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.