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

188 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
ravel8462151(None) 
gavel95815181gavel
gravel105313821gravel
navel87016571navel
ratel54224881ratel
rave75542091rave_
raved94931431raved
ravels94717071ravels
raven84723441raven
raver85631491raver
raves85441971raves
revel84423161revel
travel94112981travel
ariel55228972ariel
artel56122742artel
arval86017012arval
ave67748702_ave_
aver75931882_aver
aves76142602_aves
axel115222072_axel
babel95821692babel
bagel85116792bagel
bevel104517042bevel
brave104925502brave_
braved124817442braved
bravely15428232bravely
braver114719042braver
braves115524082braves
camel96822802camel
caravel1238202caravel
carvel114817572carvel
cave95941262cave_
caved116227562caved
caver105629062caver
caves105639702caves
cavil103816492cavil
crave105626312crave_
craved125417772craved
craven114113932craven
craver114618462craver
craves115825392craves
daven94916472daven
devel94217122devel
drave95219272drave_
drivel105110382drivel
easel54521112easel
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
fave105532962fave_
favela1237032favela
faves115331422faves
gave84634052gave_
gavels105911092gavels
grave94624872grave_
graved114818812graved
gravels113611142gravels
gravely14469062gravely
graven104513522graven
graver105018592graver
graves104624002graves
grovel104310542grovel
have106137072have_
haven114718532haven
haver115124462haver
haves116034872haves
hazel176414812hazel
hovel115017682hovel
kevel124213092kevel
label75019382label
lapel73716682lapel
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
level84116552level
marvel113712002marvel
maven104816892maven
naval85315832naval
nave75732312nave_
navels95712692navels
naves87030382naves
novel85615992novel
oaves84925612oaves
panel76023622panel
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
race66746262race_
raced87635312raced
racer75233022racer
races74943242races
rage55742352rage_
raged74829452raged
ragee65432662ragee
rages64539442rages
rail46147762ra_il
rajes125022782rajes
rake84841572rake_
raked105831422raked
rakee96031172rakee
raker94529792raker
rakes94440352rakes
rale45050562rale_
rales54947492rales
ramal74622242ramal
ramee74633852ramee
ramen75625192ramen
ramet75743142ramet
ranee55438102ranee
rape65041632rape_
raped85334622raped
raper74932752raper
rapes75740722rapes
rappel104211952rappel
rare45348432rare_
rared65738322rared
rarely93513652rarely
rarer54731702rarer
rares55247442rares
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
ratal55025112ratal
rate45458762rate_
rated65441382rated
ratels64518212ratels
rater54943282rater
rates55352012rates
raveled114113632raveled
raveler104212462raveler
ravelin102211022ravelin
ravelly13268352ravelly
ravens93916882ravens
ravers94628182ravers
ravin85624652ravin
rawer84623732rawer
raxed135622662raxed
raxes124729392raxes
rayed95127502rayed
raze135235432raze_
razed155027982razed
razee145827802razee
razer144824272razer
razes145032702razes
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reaves94127572reaves
rebel73421292rebel
reel45240532r_eel
refel84920812refel
repel74921402repel
reveal94115052reveal
revels94220572revels
revet84938842revet
riel46432382r_iel
rival85216502rival
rive75537722rive_
rived94825612rived
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
roves84834482roves
rowel84721412rowel
rubel75416832rubel
save75741362save_
saved95127112saved
saver84831252saver
saves85838632saves
tael46030712ta_el
tramel84113712tramel
trave85223032trave_
travels104711292travels
traves94222742traves
unravel1038062unravel
wave105234732wave_
waved125223582waved
waver115025702waver
waves115633922waves
wavey145115542wavey

Search took 4 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.1061685764.2
2DLD Change Limit538001883.20616781.0
3Display Results1881880.0464087.0
 (SQL Overall)1786911883.35853213.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.