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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
navels9571269(None) 
gavels105911091gavels
navel87016571navel_
naves87030381nave_s
novels95512501novels
ravels94717071ravels
angels74416172angels
anvils9219712anvils
avens86419332_avens
avers85127312_avers
aves76142602_ave_s
axels126313632_axels
babels105216722babels
bagels95712312bagels
bevels113913982bevels
camels105217082camels
carvels124914592carvels
cavers115026832cavers
caves105639702cave_s
cavils114014392cavils
davens104612912davens
devels104313902devels
easels65914552easels
eaves85231992eave_s
enamels9128162enamels
favela1237032favela
favelas1337022favelas
faves115331422fave_s
gavel95815182gavel_
gravels113611142gravels
havens124514042havens
havers124721482havers
haves116034872have_s
hazels185710082hazels
hovels125413332hovels
kevels134410712kevels
knaves13439522knave_s
knawels14344682knawels
labels84515682labels
lapels83712042lapels
lavers94526362lavers
laves86039152lave_s
levels94113282levels
marvels123810092marvels
mavens114312972mavens
nabes75427092nabe_s
naevus934592naevus
nails55730402na_ils
naively1335902naively
naives94914222naive_s
naleds7469132naleds
namely113711322namely
namers84517332namers
names74833362name_s
napes74828462nape_s
nares55544152nare_s
nasals63312462nasals
nates55238332nate_s
naval85315832naval_
navars92810572navars
nave75732312nave__
navies95218622navies
neves87021872neve_s
newels93710822newels
noels56418702n_oels
novel85615992novel_
oaves84925612oave_s
panels84716522panels
pavers115021822pavers
paves104833922pave_s
ratels64518212ratels
ravel84621512ravel_
ravens93916882ravens
ravers94628182ravers
raves85441972rave_s
revels94220572revels
savers93825922savers
saves85838632save_s
snivels10336902snivels
taels56822072ta_els
travels104711292travels
unravels1144632unravels
wavers125022472wavers
waves115633922wave_s
waveys15597012waveys

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 Filter178691825510.1101624463.6
2DLD Change Limit82551852.92328241.9
3Display Results85850.0136538.5
 (SQL Overall)178691853.04658664.1
 
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.