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

156 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
adenyl103502(None) 
adenyls1143921adenyls
acetyl11396552acetyl
adrenal838262adrenal
alanyl955482alanyl
deny86027122_deny_
phenyl1435322phenyl
acetal84314903acetal
acetyls12285353acetyls
acyl95314293a__cyl
addedly1344293addedly
addend9458453adden_d
addenda10364463addenda
addends10356053addends
adeem8311803ade_em
adeems946333adeems
adenine8311213adenine
adenoid959253adenoid
adenoma1045403adenoma
adept81219643ade_pt
adeptly1344183adeptly
adepts9117103adepts
admen84516183admen__
adnexa1433673adnexa
adnexal1543823adnexal
adonis7314063adonis
adrenals946303adrenals
adunc837433adun_c
advent102613753adven_t
advents11309473advents
aery77231683a_ery_
agedly1136463agedly
agency1237033agency
agenda837253agenda
agene65621583agen_e
agenes74720253agenes
agent65829643agen_t
agents74816293agents
agonal7410053agonal
agony96415653agony_
akene95818663aken_e
akenes104817343akenes
alanyls1084353alanyls
alienly1037503alienly
alkyl12518043a_lkyl
allyl85310543a_llyl
alphyl1484083alphyl
amen66733153amen__
amend85717753amen_d
amends94713283amends
amens75624843amen_s
ament76036543amen_t
aments85219803aments
amyl95515103a__myl
anal48037523a__nal
anenst63514983anenst
anent54931843anen_t
anil46437433a__nil
annal56520763a_nnal
anneal64812293anneal
annul55813383a_nnul
anonym1136383anonym
any68440493a__ny_
apery106517903apery_
apneal83411123apneal
ardency1346483ardency
ardent73022613arden_t
ardently1247453ardently
areal55928733are_al
arena55323813aren_a
arenas65021993arenas
arene55329413aren_e
arenes64928393arenes
arsenal739383arsenal
aryl75922343a__ryl
atonal6514023atonal
atony87218853atony_
avenge1087553avenge
avens86419333aven_s
avenue957953avenue
awny105919303a_wny_
axel115222073axe__l
axenic154210003axenic
axonal1347653axonal
azonal1568273azonal
benzyl2034163_benzyl
beryl101211673_beryl
cadence1239063cadence
cadency1545893cadency
cadent94120363caden_t
cadenza1943773cadenza
crenel84213063crenel
cresyl1135133cresyl
dactyl1234983dactyl
daedal849083daedal
darnel74312183darnel
deal56347413_de_al
debye1138903_debye
decal85523233_decal
dedal75719023_dedal
defy114921263_defy_
deil56231623_de_il
del46752753_de__l
dell56938203_de_ll
delly96023873_delly
demy105422853_demy_
den47554343_den__
denar65223293_denar
dene56643413_den_e
denes65639723_denes
deni56929393_den_i
denial74720513_denial
denim85518843_denim
dens55945073_den_s
dense65923503_dense
dent57158413_den_t
dental74319173_dental
dentil74017883_dentil
dents65031803_dents
devel94217123_devel
devil94714733_devil
dewy115419023_dewy_
dexy156118553_dexy_
dey77243373_de_y_
deys85027473_de_ys
dynel9569853_dynel
edenic9310223edenic
enol45823823__enol
evenly1236993evenly
fadedly1535453fadedly
hexyl1844463_hexyl
ideal65716393ide_al
idyl85912303id__yl
jadedly1934013jadedly
keenly1336373keenly
laden65022193laden__
ladened979053ladened
ladens74516233laden_s
leadenly1244733leadenly
lienal63912783lienal
maidenly1444563maidenly
nonyl849773_nonyl
odyl84111463od__yl
openly1137123openly
penal75228373_penal
pentyl1138813_pentyl
phenol1149253phenol
phenyls1534333phenyls
redeny102712733redeny_
renal55929503_renal
teeny85417883teeny_
thenal92712423thenal
uranyl936293uranyl
venal85523213_venal
vinyl115311623_vinyl
weeny115316163weeny_

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161565.73319660.9
3Display Results1561560.0463391.3
 (SQL Overall)1786911566.16928966.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.