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

109 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
axels12631363(None) 
axel115222071axel_
axes117337851axe_s
axils127217501axils
axles125219471axles
aals49941142a_als
abele76323252abele
abeles84719392abeles
abets75621672abets
ables75935542ables
aces67645092ace_s
acyls104211522acyls
agers65027852agers
ages55844592age_s
ails45654712a_ils
akees96119242akees
akela9311342akela
akelas10311192akelas
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
alls46740922a_lls
als36663022a__ls
amens75624842amens
amyls104512692amyls
anele55628832anele
aneles64626292aneles
anes45255932ane_s
angels74416172angels
anils56326722anils
apers76629132apers
apes66047432ape_s
appels104312792appels
areas55935772areas
ares45871022are_s
ariels65119372ariels
arils58732202arils
arles56735742arles
artels66216232artels
aryls87015812aryls
ates45047922ate_s
avens86419332avens
avers85127312avers
aves76142602ave_s
awes76037552awe_s
awls75926092a_wls
awols84713522awols
axal116520492axal_
axe108239492axe__
axed128829612axe_d
axil116424452axil_
axile126020512axile
axis116127912ax_is
axle116424602ax_le
axled135315812axled
axons125517932axons
ayes76543512aye_s
babels105216722babels
bagels95712312bagels
bels66142492_bels
camels105217082camels
cels65534972_cels
dels56745472_dels
duels65619232duels
easels65914552easels
eels46536742_eels
els37645722__els
excels1536662excels
execs14539722execs
exes116530812exe_s
expels1547172expels
faxes155726652faxe_s
feels85223042feels
fuels87117352fuels
gavels105911092gavels
gels56836102_gels
hazels185710082hazels
heels85625532heels
keels94622412keels
koels94613902koels
labels84515682labels
lapels83712042lapels
laxes125430092laxe_s
maxes145629532maxe_s
mels65941532_mels
navels95712692navels
noels56418702noels
oxes116530722oxe_s
panels84716522panels
paxes144928422paxe_s
peels75226422peels
pixels15478532pixels
ratels64518212ratels
ravels94717072ravels
raxes124729392raxe_s
reels55333262reels
riels55121332riels
saxes125229342saxe_s
seels55632822seels
sels46345982_sels
taels56822072taels
taxers134015282taxers
taxes124730822taxe_s
taxols13328632taxols
teels55726372teels
tels46841692_tels
waxers164014302waxers
waxes155825502waxe_s
zaxes215113822zaxe_s

Search took 2 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.296603685.8
2DLD Change Limit538001091.64032804.9
3Display Results1091090.0333303.0
 (SQL Overall)1786911091.96990752.2
 
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.