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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
anodize173868(None) 
anodized1946461anodized
anodizes1837961anodizes
agonize172911402agonize
anode65021042anod__e
anodic92813132anodi_c
anodyne1144162anodyne
anomie83215962anomi_e
atomize183111822atomize
avodire1143762avodire
azotize1537082azotize
canonize1959832canonize
iodize164112592_iodize
abode85518813abod__e
aboding11410123aboding
acnode938203acnod__e
aconite9315473aconite
adoze155713833a__doze
adze1412820573a__d_ze
aedile73716653a_edile
aedine73218393a_edine
agatize1739833agatize
agenize172910153agenize
agnize16329563a_gnize
agonise83112693agonise
agonized19258993agonized
agonizes182610583agonizes
alodia71112453alodi_a
alodial899953alodial
alodium1047583alodium
amidine103613853amidine
amortize1987743amortize
amosite9313163amosite
analogize19156543analogize
analyze19167013analyze
anatomize2087113anatomize
anglice1089213anglice
anguine839913anguine
anile54634463an__ile
aniline7418473aniline
anime75423203an__ime
anise55129703an__ise
anodal72512123anod_al
anodes74418763anod_es
anodizing2046873anodizing
anodynes1244443anodynes
anoint6423633ano_int
anole55330383ano__le
anolyte10159003anolyte
anomic102516303anomi_c
anomies93316993anomies
anopia83412393anopi_a
anopias92412483anopias
anoxia133510023anoxi_a
anoxias14259113anoxias
anoxic152610673anoxi_c
antlike11312073antlike
anytime1246043anytime
anywise1345203anywise
aphorize2249043aphorize
apprize2038183apprize
arabize1849343arabize
arborize1988963arborize
assize1538633a_ssize
atomise93013823atomise
atomized20279323atomized
atomizer19298533atomizer
atomizes192711433atomizes
audile73315303a_udile
avodires1244123avodires
azotise1637073azotise
azotized1745673azotized
azotizes1636853azotizes
banalize191010933banalize
bodice11711423_bodice
bromize20238823bromize
calorize192712733calorize
canalize19914493canalize
canonise10511093canonise
canonized2147683canonized
canonizer2046693canonizer
canonizes2049593canonizes
caponize2139113caponize
ebonize1838153ebonize
endite73817593en_dite
endive103310473en_dive
erotize16311663erotize
faradize21237823faradize
foodie104413843foodi_e
goodie83613993goodi_e
hoodie105116143hoodi_e
idolize1737783idolize
indie63721473in_di_e
indite73520323in_dite
inosine7314273inosine
inosite7314063inosite
iodide84812933_iodide
iodine74618653_iodine
iodise74214943_iodise
iodized18969163_iodized
iodizer17408663_iodizer
iodizes173911723_iodizes
ionize154613873_ionize
ironize16610373ironize
jarovize2743763jarovize
lanoline8311953lanoline
lionize1668823lionize
melodize2046663melodize
nardine82712573nardine
noddle83211363_noddle
node513036883_nod__e
nodi56626743_nodi__
nodose738883_nodose
nodule7309803_nodule
noise55723733_no_ise
norite63221133_norite
notice8313443_notice
novice1138433_novice
nowise9511073_nowise
nudie65118673_nudi_e
odorize1737403odorize
oxidize2444983oxidize
ozonize1546293ozonize
podite93315353_podite
randomize2144163randomize
sanidine939853sanidine
sanitize171410083sanitize
snooze15439993sno_oze
undine7817263un_dine
unionize1747063unionize
unisize1647343unisize
unitize16310033unitize
valorize20239613valorize
vaporize22239173vaporize
woodie103513613woodi_e

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271356.75019855.9
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.23624694.7
 
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.