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 “ravin” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
ravin8562465(None) 
mavin105722951mavin
pavin105623201pavin
rain46251731ra_in
raven84723441raven
ravine95522221ravine
raving105128851raving
ravins94622561ravins
rawin85521471rawin
savin84625081savin
agin56132712_agin
ain37579092_a_in
akin86328032_akin
amin66042252_amin
avian84616052_avian
avid88325962_avid
avion84218342_avion
ayin76331742_ayin
basin75026922basin
brain76229382bra_in
bravi104715752bravi_
braving133714612braving
cabin94820942cabin
cain65643912ca_in
cavie104621592cavie
cavil103816492cavil
caving124822612caving
covin105621122covin
craven114113932craven
craving134015732craving
daven94916472daven
davit93424592davit
drain65222892dra_in
fagin9216572fagin
fain75840562fa_in
flavin1239302flavin
gain56042162ga_in
gamin84423002gamin
gradin83517482gradin
grain65126252gra_in
gratin74520582gratin
graven104513522graven
gravid113710982gravid
graving123114562graving
haven114718532haven
having134220372having
kain85334292ka_in
lain46146282la_in
lapin75222922lapin
laving104623572laving
layin84720332layin
levin84816412levin
main65345522ma_in
matin75132852matin
maven104816892maven
mavie104722562mavie
mavins115119182mavins
mavis105622722mavis
mayvin1436522mayvin
pain65647242pa_in
patin76832852patin
pavan106518472pavan
pavid115717002pavid
paving124519742paving
pavins114919662pavins
pavis106422732pavis
rabbin103112302rabbin
rabic93817402rabic
rabid84520782rabid
racing95030532racing
racon75422142racon
radian74117272radian
radii64016412radii
radio64922492radio
radix134414602radix
radon64620502radon
ragi56032282ragi_
raging85126432raging
ragis66325602ragis
rai37658222ra_i_
raia46638382ra_ia
raid55243072ra_id
rail46147762ra_il
rains55140232ra_ins
rainy85921082ra_iny
rais45252622ra_is
raisin62716922raisin
raki87127832raki_
raking114728422raking
rakis95323442rakis
ramen75625192ramen
rami66034092rami_
ramie75027822ramie
ran38266622ra__n
rani46640112rani_
ranid66429332ranid
ranis55235832ranis
rapid86422032rapid
rapine85023082rapine
raping94829852raping
rapini84714682rapini
raring74332872raring
rasing74330832rasing
ratan53722662ratan
ratine65131822ratine
rating74938702rating
ratio55227582ratio
ration64226012ration
ratlin64116522ratlin
rave75542092rav_e
raved94931432raved
ravel84621512ravel
ravelin102211022ravelin
ravens93916882ravens
raver85631492raver
raves85441972raves
ravined115411822ravined
ravines104220232ravines
ravings114614502ravings
ravish123414032ravish
rawins95617622rawins
raxing144321022raxing
raying105027192raying
rayon83815702rayon
razing164524542razing
reagin74915532reagin
reaving113820532reaving
rein46040892r_ein
renin54830032renin
repin75324702repin
resin54131052resin
rewin85623962rewin
ricin74620212ricin
rin36663182r__in
riven85121622riven
riving104521422riving
robin74820282robin
rosin55325312rosin
roven85521972roven
roving103618742roving
ruin47430512r_uin
rutin55421342rutin
sabin74924952sabin
sain45551292sa_in
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savine94220282savine
saving104724512saving
savins93923132savins
spavin114210652spavin
tain45548072ta_in
takin94921302takin
train56529112tra_in
vain75233002va_in
wain75840202wa_in
waving134018202waving
zayin174512042zayin

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001581.68631909.8
3Display Results1581580.0463434.8
 (SQL Overall)1786911582.04587379.5
 
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.