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

198 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
raven8472344(None) 
craven114113931craven
daven94916471daven
graven104513521graven
haven114718531haven
maven104816891maven
ramen75625191ramen
rave75542091rave_
raved94931431raved
ravel84621511ravel
ravens93916881ravens
raver85631491raver
raves85441971raves
ravin85624651ravin
riven85121621riven
roven85521971roven
amen66733152_amen
arpen74418042arpen
ave67748702_ave_
avens86419332_avens
aver75931882_aver
aves76142602_aves
brave104925502brave_
braved124817442braved
braver114719042braver
braves115524082braves
brazen174812452brazen
carven114716662carven
cave95941262cave_
caved116227562caved
caver105629062caver
cavern115312452cavern
caves105639702caves
coven106925042coven
crave105626312crave_
craved125417772craved
cravens124010112cravens
craver114618462craver
craves115825392craves
davens104612912davens
dawen95413722dawen
doven94718552doven
drave95219272drave_
driven105210142driven
eaten55323052eaten
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
even75222272_even
fave105532962fave_
faves115331422faves
gaen57329602ga_en
gave84634052gave_
gavel95815182gavel
given95915282given
graben9419722graben
grave94624872grave_
graved114818812graved
gravel105313822gravel
graver105018592graver
graves104624002graves
haen76229452ha_en
have106137072have_
havens124514042havens
haver115124462haver
haves116034872haves
heaven123912602heaven
kraken955882kraken
laden65022192laden
laten54328342laten
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
leaven95013072leaven
liven85021732liven
mavens114312972mavens
mavin105722952mavin
nave75732312nave_
navel87016572navel
naves87030382naves
oaken95814382oaken
oaten55222402oaten
oaves84925612oaves
oven76624142_oven
paten74827342paten
pavan106518472pavan
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
pavin105623202pavin
proven114314772proven
race66746262race_
raced87635312raced
racer75233022racer
races74943242races
racon75422142racon
radon64620502radon
rage55742352rage_
raged74829452raged
ragee65432662ragee
rages64539442rages
ragmen93712182ragmen
rain46251732ra_in
rajes125022782rajes
rake84841572rake_
raked105831422raked
rakee96031172rakee
raker94529792raker
rakes94440352rakes
rale45050562rale_
rales54947492rales
ramee74633852ramee
ramet75743142ramet
ran38266622ra__n
ranee55438102ranee
rape65041632rape_
raped85334622raped
raper74932752raper
rapes75740722rapes
rappen103512712rappen
rare45348432rare_
rared65738322rared
rarer54731702rarer
rares55247442rares
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
ratan53722662ratan
rate45458762rate_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
ratten64217382ratten
ravelin102211022ravelin
ravels94717072ravels
ravened115012282ravened
ravener104110732ravener
ravers94628182ravers
ravine95522222ravine
raving105128852raving
ravins94622562ravins
rawer84623732rawer
rawin85521472rawin
raxed135622662raxed
raxes124729392raxes
rayed95127502rayed
rayon83815702rayon
raze135235432raze_
razed155027982razed
razee145827802razee
razer144824272razer
razes145032702razes
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reaves94127572reaves
revel84423162revel
revet84938842revet
ripen75619262ripen
risen54621882risen
rive75537722rive_
rived94825612rived
river85731692river
rives85336002rives
rivet85636362rivet
rouen54920902rouen
rove75136982rove_
roved95323552roved
rover85527372rover
roves84834482roves
rowen84921152rowen
rumen74419502rumen
save75741362save_
saved95127112saved
saver84831252saver
saves85838632saves
savin84625082savin
seven84118312seven
shaven124213302shaven
taken94819142taken
tavern9428932tavern
trave85223032trave_
travel94112982travel
traves94222742traves
waken124818472waken
wave105234732wave_
waved125223582waved
waver115025702waver
waves115633922waves
wavey145115542wavey
waxen154911812waxen
woven115215172woven
yamen104115182yamen
zazen1337282zazen

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 Limit538001981.70331591.3
3Display Results1981980.0633142.9
 (SQL Overall)1786911982.07985950.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.