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

106 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
adenoid95925(None) 
adenoids1056861adenoids
adenoidal1143662adenoidal
adenoma1045402adenoma
adenosis946342adenosis
ameboid1277232ameboid
aneroid8314012aneroid
catenoid1149112catenoid
ctenoid1078682ctenoid
dentoid9310662_dentoid
devoid1189362_devoid
glenoid937802glenoid
hyenoid1448612hyenoid
acaroid103512313acaroid
actinoid1148023actinoid
addend9458453adden__d
adeemed1145393adeemed
adenine8311213adenine
adenitis947453adenitis
adenomas1144813adenomas
adenoses947903adenoses
adenosine1054183adenosine
adenyl1035023aden_yl
adenyls1143923adenyls
adjoin14107293ad_join
adnoun757033ad_noun
adonis7314063adon_is
adroit7518793ad_roit
aeonic83517043a_eonic
agatoid948623agatoid
agented939433agented
algoid83011473a_lgoid
amberoid1346433amberoid
ambroid1238883ambroid
amend85717753amen__d
amended11328313amended
amentia9310153amentia
ammonoid13104803ammonoid
amoeboid1344113amoeboid
amyloid1348543amyloid
anconoid1146463anconoid
android9311513android
aneroids9310203aneroids
annelid838733annelid
anthoid11313313anthoid
araneid8310803araneid
arenose7311383arenose
arenous7314183arenous
aroid65428343a__roid
arytenoid1353373arytenoid
asteroid9511213asteroid
athetoid1246743athetoid
avenged1245503avenged
avoid95516683a__void
axenic154210003axen_ic
cadenced1435523cadenced
catenoids1246443catenoids
ceboid11310653_ceboid
cheloid13310833cheloid
conoid9818883_conoid
crinoid1039943crinoid
deltoid938573_deltoid
demoed103713443_demoed
dendroid1145923_dendroid
deni56929393_den_i_
denied84318633_denied
denim85518843_den_im
denned84215633_denned
denote74118043_denote
denoted93512763_denoted
dented84120513_dented
dentil74017883_dentil
dentin73919573_dentin
dermoid1138523_dermoid
desmid1048363_desmid
desmoid1137103_desmoid
devoir1076033_devoir
droid74218543_d_roid
edenic9310223eden_ic
emeroid101511183emeroid
gadoid9310463gad__oid
ganoid8314443_ganoid
geoid74215763_ge_oid
haemoid1337203haemoid
hemoid12313513_hemoid
hypnoid1647883hypnoid
identic1038043identic
keloid11812623_keloid
ladened979053laden_ed
lentoid8310683_lentoid
lianoid837533lianoid
meloid9616003_meloid
myeloid13108123myeloid
naevoid1194593naevoid
nevoid1098803_nevoid
oceloid1037973oceloid
odontoid1043553odontoid
paranoid11311143paranoid
pyrenoid1446873pyrenoid
quinoid1737353quinoid
racemoid1344813racemoid
solenoid947873solenoid
sphenoid1446323sphenoid
steroid81314873steroid
theroid11313403theroid
trendoid1045453trendoid

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 Limit1340271066.92019368.1
3Display Results1061060.0333212.1
 (SQL Overall)1786911067.37624226.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.