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

60 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
azote14441634(None) 
azole145118031azole
azoted16388591azoted
azotes154312221azotes
azoth17389901azoth
abate76627842abate
abode85518812abode
above105414322above
acute74720362acute
adobe84814712adobe
adore65723672adore
adoze155713832adoze
afore85818602afore
agate66525152agate
agone65924552agone
alate55340322alate
aloe45540192alo_e
alone55732962alone
amole75724592amole
anode65021042anode
anole55330382anole
ante46538902a_nte
arete56031352arete
arose55832082arose
ate37059242a__te
atone56527982atone
awoke124912002awoke
axite125218252axite
axone125918472axone
azide155617162azide
azine146721412azine
azo128233392azo__
azoic162912062azoic
azoles154614612azoles
azon135725052azo_n
azons146518252azons
azoths18366202azoths
azotic172711632azotic
azotise1637072azotise
azotize1537082azotize
azure14911482azure
capote10315732capote
cote66648732_cote
dote55442882_dote
emote75421192emote
epazote1843702epazote
garote7717952garote
mote67048082_mote
note46239962_note
ozone14310612ozone
quote143714772quote
rote46249022_rote
sapote8314362sapote
shote85526102shote
smote75820282smote
tote46643672_tote
vote74728622_vote
wrote84717482wrote
zlote143912942zlote
zone135231082_zone

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.326548131.9
2DLD Change Limit53800602.29623432.1
3Display Results60600.0331818.2
 (SQL Overall)178691602.65567303.6
 
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.