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

176 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
anonym113638(None) 
anonyms1235441anonyms
antonym1246511antonym
acronym1445672acronym
agony96415652agony_
allonym1244732allonym
annoy869712annoy_
annoys967522annoys
anomy105113392anomy_
anon46134852anon__
antonyms1345872antonyms
antonymy1643872antonymy
atony87218852atony_
autonym1246632autonym
caconym1644952caconym
eponym1345792eponym
exonym1844582exonym
nonyl849772_nonyl
paronym1437502paronym
synonym1544072synonym
abohm1247973abo_hm
acronyms1544993acronyms
adenyl1035023adenyl
adonis7314063adonis
aeon45634613aeon__
aeonic83517043aeonic
aeons57624653aeon_s
agon56531883agon__
agonal7410053agonal
agone65924553agon_e
agones75719863agones
agonic93515143agonic
agons66423783agon_s
ahoy101919183aho_y_
alanyl955483alanyl
allonyms1344363allonyms
alone55732963alon_e
along65419493alon_g
among85813303amon_g
anadem939183anadem
ananke1038283ananke
ancon75718233ancon__
anconal939423anconal
ancone83916953ancon_e
ancones93116343ancones
anenst63514983anenst
anent54931843anen_t
angry9310863angry_
anion55028813anion__
anionic9312873anionic
anions64123033anion_s
anna45529013an_n_a
annal56520763an_nal
annas55824883an_nas
annex12310883an_nex
annona648873annona
annonas738793annonas
annoyed1185873annoyed
annoyer1095603annoyer
annul55813383an_nul
anoa45634473ano__a
anoas57226493ano_as
anodal72512123anodal
anode65021043ano_de
anodes74418763anodes
anodic92813133anodic
anodyne1144163anodyne
anoint6423633anoint
anoints7311063anoints
anole55330383ano_le
anoles64827433anoles
anolyte10159003anolyte
anomic102516303anomic
anomie83215963anomie
anonymity1753323anonymity
anonymous1443893anonymous
anopia83412393anopia
anorak1038923anorak
anoxia133510023anoxia
anoxic152610673anoxic
anthem113410343anthem
antonymic1645343antonymic
antrum8611313antrum
antsy85712793antsy_
any68440493a__ny_
anyon85615223anyon__
anyone94612733anyon_e
anyons94513503anyon_s
aroynt9312893aroynt
astony9510523astony_
atom67824523ato__m
atomy107415193atomy_
atonal6514023atonal
atone56527983aton_e
atoned75417543atoned
atoner64817193atoner
atones65225773atones
atonia63816513atonia
atonic83420473atonic
atopy106813393atopy_
autonyms1345983autonyms
awny105919303a_wny_
axon115524303axon__
axonal1347653axonal
axone125918473axon_e
axoneme1644783axoneme
axones134614513axones
axonic154312723axonic
axons125517933axon_s
azon135725053azon__
azonal1568273azonal
azonic175513153azonic
azons146518253azon_s
barony115915303barony_
bonny105816623bonny_
bony96732083_bony_
caconyms1744003caconyms
caconymy2042773caconymy
canny105817693can_ny_
canon74725303canon__
canonic11312933canonic
canonry1235923canonry
canons85522063canon_s
canopy1337723canopy_
cony96537833_cony_
crony105918673crony_
ebony104511513ebony_
enorm74415643eno_rm
enzym1964393en_zym
eponyms1444853eponyms
eponymy1743493eponymy
ethnonym1642563ethnonym
exonyms1944433exonyms
fanny114816043fan_ny_
fanon84619013fanon__
fanons96115213fanon_s
goony95519783goony_
homonym1745253homonym
hyponym2044423hyponym
incony1139083incony_
irony85015903irony_
loony86918963loony_
metonym1445573metonym
mony96830013_mony_
moony104818273moony_
nanny84813813nanny_
nom510450643_no__m
nona46929063_non_a
nonas55126653_nonas
nonce75719823_nonce
noncom1039683_noncom
none45743173_non_e
nones55639133_nones
nonet54540843_nonet
nonyls957853_nonyls
norm66429813_no_rm
nosy76322893_nosy_
notum7611693_notum
oniony9369703oniony_
onyx1478363__onyx
paronyms1546553paronyms
peony105717563peony_
phony136715443phony_
pony96434053_pony_
saxony1636233saxony_
snowy115011563snowy_
sonny85016103sonny_
stony85818643stony_
synonyme1643693synonyme
synonyms1643893synonyms
synonymy1543063synonymy
tannoy958353tannoy_
tannoys1055553tannoys
tautonym1342983tautonym
tony75635153_tony_
toponym1445163toponym

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161765.03322395.4
3Display Results1761760.0602933.3
 (SQL Overall)1786911765.48332590.0
 
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.