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

116 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
navel8701657(None) 
gavel95815181gavel
naval85315831naval
nave75732311nave_
navels95712691navels
naves87030381naves
novel85615991novel
ravel84621511ravel
angel65019562angel
anvil82712602anvil
ave67748702_ave_
aver75931882_aver
aves76142602_aves
axel115222072_axel
babel95821692babel
bagel85116792bagel
bevel104517042bevel
camel96822802camel
carvel114817572carvel
cave95941262cave_
caved116227562caved
caver105629062caver
caves105639702caves
cavil103816492cavil
daven94916472daven
devel94217122devel
easel54521112easel
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
enamel81210112enamel
fave105532962fave_
favela1237032favela
faves115331422faves
gave84634052gave_
gavels105911092gavels
gravel105313822gravel
have106137072have_
haven114718532haven
haver115124462haver
haves116034872haves
hazel176414812hazel
hovel115017682hovel
kevel124213092kevel
knave12389462knave_
knaves13439522knaves
knawel13415412knawel
label75019382label
lapel73716682lapel
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
level84116552level
marvel113712002marvel
maven104816892maven
nabe66029492nabe_
nabes75427092nabes
nae35952742na_e_
naevi867872naevi
nail45838652na_il
naive85116212naive_
naively1335902naively
naiver94311352naiver
naives94914222naives
naked105320852naked
naled65525052naled
name65637412name_
named85223062named
namely113711322namely
namer75622102namer
names74833362names
nape65230802nape_
napes74828462napes
nares55544152nares
nasal56217592nasal
natal53921492natal
nates55238332nates
navar83912732navar
navies95218622navies
navvy14696682navvy
navy107518632nav_y
neve76224832neve_
never86218642never
neves87021872neves
newel86114132newel
nival84915772nival
noel45226552n_oel
novels95512502novels
oaves84925612oaves
panel76023622panel
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
ratel54224882ratel
rave75542092rave_
raved94931432raved
ravels94717072ravels
raven84723442raven
raver85631492raver
raves85441972raves
revel84423162revel
save75741362save_
saved95127112saved
saver84831252saver
saves85838632saves
snivel9368852snivel
tael46030712ta_el
travel94112982travel
unravel1038062unravel
wave105234732wave_
waved125223582waved
waver115025702waver
waves115633922waves
wavey145115542wavey

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.1561145455.1
2DLD Change Limit538001161.89028465.6
3Display Results1161160.0303866.7
 (SQL Overall)1786911162.07686074.7
 
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.