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

149 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
adenoses94790(None) 
adenosis946341adenosis
adenines9310192adenines
adenoids1056862adenoids
adenomas1144812adenomas
adenosines1193612adenosines
adiposes1137172adiposes
adonises92611432adonises
ageneses939302ageneses
anemoses10159432anemoses
arenose7311372arenose_
avenses1049642aven_ses
demoses103815822_demoses
denotes83817002_denotes
deposes103117212_deposes
stenoses8310442stenoses
abioses9311493a_bioses
acerose9310893acerose_
acetones10310033acetones
acetose938843acetose_
acidoses1136773acidoses
acinose938583acinose_
acnodes1037833a_cnodes
adenine8311213adenine_
adenitis947433adenitis
adenitises1145723adenitises
adenoid959253adeno_id
adenoma1045403adeno_ma
adenosine1054183adenosine
adenyls1143923aden_yls
adipose1036653adipose_
adiposis1146253adiposis
admasses1135413admasses
adnouns835453ad_nouns
adobes94411533ad__obes
adores74420723ad__ores
advises11138973ad_vises
aegises8311373a_egises
aerobes9311493a_erobes
agaroses938823agaroses
agencies1138743agencies
agenes74720253agen__es
agenesis938043agenesis
agenizes18269743agenizes
agonises92613163agonises
akenes104817343aken__es
aldoses8311203a_ldoses
alehouses1246583alehouses
amitoses1039053amitoses
amyloses1347223amyloses
anemones10249473anemones
anemosis10148073anemosis
anises64826693a__nises
anodes74418763a__nodes
anoles64827433a__noles
anuses66218773a__nuses
apodoses1136653apodoses
apposes11511473a_pposes
ardencies1247853ardencies
arenes64928393aren__es
arenites8917103arenites
arenous7314183areno_us
areoles71016953are_oles
arkoses113910833a_rkoses
asepses946363ase_pses
athetoses1244973athetoses
avenges1157543aven_ges
avenues1057183aven_ues
azygoses2163313azygoses
badnesses1239253badnesses
bluenoses1144223bluenoses
cadences1338473caden_ces
cadencies1447323cadencies
caseoses1039293case_oses
cenotes92814543_cenotes
censes83721803_cen_ses
conenoses1188903conenoses
cyanoses1337423cyanoses
daemones11209163daemones
debases103814133_debases
debones103315113_debones
decodes113914983_decodes
defuses114814593_defuses
degases93413103_degases
delouses9310013_delouses
demises103719563_demises
demotes104717673_demotes
denes65639723_den__es
dengues938183_dengues
denies74729643_den_ies
denote74118043_denote_
denoted93512763_denoted
dense65923503_den_se_
denser74115193_den_ser
densest83112473_den_sest
denudes91510043_denudes
depones103717093_depones
depose94215763_depose_
deposed113412023_deposed
deposer104011843_deposer
deposers11359243_deposers
detoxes1538803_detoxes
devises114116763_devises
devotes113713753_devotes
doses65938503_d__oses
dynodes1235453_dynodes
enosis63816423__enosis
eposes84418783__eposes
eroses65327053__eroses
ethnoses1146083ethnoses
flenses1039473flen_ses
geneses82613523_geneses
genoises939253_genoises
genomes103611703_genomes
genuses83510883_genuses
gnoses76515163__gnoses
hardnoses1346233hardnoses
hawknoses1942413hawknoses
hexoses17228883_hexoses
hognoses12108133hognoses
hypnoses1646633hypnoses
kenosis11369003_kenosis
ketoses114912873_ketoses
lenses64620893_len_ses
madnesses1239833madnesses
mannoses1039083mannoses
meioses9310833_meioses
menses84222453_men_ses
noses55435643___noses
penises9318193_penises
pentoses10312893_pentoses
pycnoses1554973pycnoses
pyknoses1783573pyknoses
reposes94021263_reposes
sadnesses10310303sadnesses
selenoses947463selenoses
senores73218113_senores
senses63923943_sen_ses
sideroses1047353sideroses
spenses92913573spen_ses
stenosed946343stenosed
stenosis847993stenosis
tenses64722553_ten_ses
tubenoses11104363tubenoses
vaginoses1344143vaginoses
venose9310843_venose_
venuses103111413_venuses
xeroses143612823_xeroses
zoonoses1746203zoonoses

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621496.29623215.1
3Display Results1491490.0602483.3
 (SQL Overall)1786911496.76226425.8
 
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.