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

124 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
anemone911945(None) 
anemones10249471anemones
acetone9310792acetone
ancone83916952an_cone
anemoses10159432anemoses
anymore1256242anymore
anyone94612732an_yone
abalone938893abalone
acerose9310893acerose
acetones10310033acetones
acetose938843acetose
adenine8311213adenine
aedine73218393a_edine
aeon45634613a_e_on_
aeons57624653a_e_ons
aerobe8412403a_erobe
agelong934973agelong
agemate101210583agemate
agene65621583age__ne
agone65924553a__gone
akene95818663ake__ne
alamode1038153alamode
aleurone846113aleurone
alexine142410543alexine
alimony1236013alimony
almond91410433a_lmond
almoner949383a_lmoner
alone55732963a__lone
alumine9412693alumine
amarone9311193amarone
amidone10349303amidone
amine75835373a__mine
ammine10314483a_mmine
ammono1047373a_mmono
amole75724593a__mole
among85813303a__mong
anaerobe1044823anaerobe
anagoge9166643anagoge
ancon75718233an_con_
ancones93116343an_cones
anecdote1183663anecdote
anele55628833ane__le
aneling82719503aneling
anemia82613573anem_ia
anemias92512143anemias
anemic102713693anem_ic
anemosis10148073anemosis
anent54931843ane__nt
aneroid8313983aneroid
anethole1146253anethole
anguine839913anguine
aniline7418473aniline
animate91617213animate
anime75423203anim__e
anion55028813an_ion_
anions64123033an_ions
anisole71010833anisole
anklebone1552073anklebone
annona648873an_nona
anode65021033an__ode
anodyne1144153anodyne
anole55330373an__ole
anomie83215963anom_ie
anon46134853an__on_
anserine8313083anserine
antelope1047303antelope
antimine10714753antimine
antimony1358303antimony
anyon85615223an_yon_
anyons94513503an_yons
arene55329413are__ne
arenose7311373arenose
areole61017283are_ole
atemoya1242933atemoya
atone56527983a__tone
awesome1245573awesome
axeman1538103axeman_
axemen1547493axemen_
axone125918473a__xone
begone9512133_begone
cabezone2144433cabezone
canzone1858813can_zone
daemon9279593daemon_
daemones11209163daemones
daemons10269233daemons
debone93714783_debone
demode104013463_demode
demon86520313_demon_
demons94917723_demons
demote94817803_demote
depone93616553_depone
emote75421193__emote
enamine91214293enamine
gemote94613023_gemote
gnomon936183gnomon_
gnomons1035753gnomons
hexone16289233_hexone
hormone12410503hormone
intone61115423in_tone
kakemono1341883kakemono
ketone105014533_ketone
lemon75618183_lemon_
lemons84415053_lemons
lemony11419553_lemony
leone55018823_le_one
mnemonic1445233mnemonic
nene45932063_ne__ne
neon47026423_ne_on_
neoned7311483_ne_oned
neons55818683_ne_ons
neurone739433_neurone
none45743173_n__one
panettone1144343panettone
pinecone1246063pinecone
premune1138933premune
racemose1245003racemose
redone74820053_redone
remote84222603_remote
remove116115573_remove
rezone153814783_rezone
someone938813someone
spumone1154383spumone
undone7914253un_done
xanthone1847113xanthone

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.1601116818.8
2DLD Change Limit1340271247.23318529.9
3Display Results1241240.0304133.3
 (SQL Overall)1786911247.42324072.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.