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

261 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
adenine831121(None) 
adenines9310191adenines
adenosine1054182adenosine
aedine73218392a_edine
agenize172910152agenize
alanine7316862alanine
alexine142410542alexine
arenite71017712arenite
asinine7310722asinine
define104718142_define
dentine83320242_dentine
hyenine1336952hyenine
ladening1078822ladening
venine93718432_venine
acarine9316003acarine
acetin8314693acetin_
acetins9313173acetins
acetone9310793acetone
aconite9315473aconite
adding93914963ad_ding
addling10229833addling
adeeming1254793adeeming
adenitis947433adenitis
adenoid959253adenoid
adenoids1056863adenoids
adenoma1045403adenoma
adenoses947903adenoses
adenosines1193613adenosines
adenyl1035023aden_yl
adenyls1143923adenyls
adhering1338883adhering
adhesive1543803adhesive
adjoin14107293adjoin_
adjoined1743513adjoined
adjoins1585983adjoins
adjoint15108283adjoint
admire949933ad_mire
adnate72913483ad_nate
adonis7314063adoni_s
adonises92611433adonises
adoring9412523adoring
adorning1087323adorning
adrenaline1153733adrenaline
adventive1645813adventive
advice12107883ad_vice
advise10139223ad_vise
adzing174110013ad_zing
aedile73716653a_edile
aerie54634603a_eri_e
affine12310503a_ffine
ageing84213403age_ing
agene65621583age__ne
agenized19257733agenized
agenizes18269743agenizes
agenting1039383agenting
agentive1248043agentive
agnize16329563a_gnize
agonise83112693agonise
agonize172911403agonize
airline7315033airline
akene95818663ake__ne
alanin6317273alanin_
alanines8314803alanines
alanins7315803alanins
alevin92511513alevin_
alevins102110573alevins
alewife1344923alewife
alexin132311483alexin_
alexines15258503alexines
alexins141910663alexins
algerine9810283algerine
aliening91510893aliening
aline57243153a__line
alining81917043alining
alkine104916803a_lkine
alpine84417373a_lpine
alumine9412693alumine
alunite7311633alunite
alvine94614583a_lvine
amandine1148553amandine
amending12308913amending
amenity1238333amenity
amidine103613853amidine
amine75835383a__mine
ammine10314493a_mmine
andesite949453andesite
aneling82719503aneling
anemone9119453anemone
anguine839913anguine
anile54634463a__nile
aniline7418473aniline
anime75423203a__nime
anise55129703a__nise
anserine8313093anserine
apelike13310533apelike
archine125817053archine
arcsine94512393arcsine
arene55329413are__ne
arenites8917103arenites
arenose7311373arenose
argentine1047893argentine
arginine948563arginine
arsenide9116333arsenide
arsenite8119663arsenite
arsine64021043a_rsine
atoning83514873atoning
avenge1087553aven_ge
avenging1345863avenging
avenue957953aven_ue
aweing103911253awe_ing
awning105013393a_wning
axenic154210003axeni_c
azine146721413a__zine
baseline10310753baseline
beeline93314723beeline
benne76521123_ben_ne
benzine1839343_benzine
cadence1239063caden_ce
cadencing1544963cadencing
canine83826703_canine
cayenne1244603cayen_ne
codeine103815033code_ine
conine84528553_conine
cyanine122911513cyanine
damning114211633damning
darning93817333darning
dateline9810353dateline
davening13258873davening
dawning124111013dawning
deadening1277583deadening
deaning94020473_deaning
debone93714783_debone
decane93818873_decane
decide104116873_decide
decile94619213_decile
decline103716613_decline
defile105216663_defile
defined123813823_defined
definer114413773_definer
defines114118683_defines
deice84320033_de_ice
deking125614553_deking
delaine8314793_delaine
delime9314043_delime
demise94618323_demise
dene56643413_de__ne
dengue838253_dengue
deni56929393_deni__
denial74720513_denial
denied84318633_denied
denier74420693_denier
denies74729643_denies
denim85518843_deni_m
denimed1159233_denimed
denims95214323_denims
denizen1737663_denizen
denned84215633_den_ned
denning93515173_denning
denote74118043_denote
dense65923503_den_se
dentin73919573_dentin_
dentines93418403_dentines
denting94422183_denting
dentins83419223_dentins
denude8169353_denude
denying123711293_denying
depone93616553_depone
deride84420033_deride
derive103817043_derive
desire7415303_desire
destine83719953_destine
detinue85010033_detinue
device124512163_device
devise104215753_devise
dewing114115703_dewing
dexie134716893_dexi_e
dezinc1836053_dezinc
dine55555333_d__ine
dining84525133_dining
divine103514463_divine
domine92918253_domine
donne65520463_don_ne
dunite7315013_dunite
dwine95616143_d_wine
edenic9310223edeni_c
emetine9712943emetine
endexine1646083endexine
engine71114863__engine
eserine7415903eserine
evening11310223evening
exine125518493__exine
fadein1068843fade_in_
fadeins1168503fade_ins
feline94820143_feline
ferine96422583_ferine
galenite91210063galenite
gardening1236513gardening
genie66124923_geni_e
genuine838373_genuine
guanine8810543guanine
hardening1438023hardening
havening15258553havening
jadeite1546403jade_ite
jadelike2035993jadelike
keening123713153keening
latening9711493latening
leadening1176733leadening
lenite6719983_lenite
leonine7311233leonine
maddening1445113maddening
madeleine1244133madeleine
maderize2049073maderize
meninx1538703_meninx
myeline1238253myeline
nine45842173___nine
olefine1038023olefine
oleine6313793ole_ine
omening10310093omening
opening1039923opening
pavonine1346663pavonine
peening103318303peening
penile82219603_penile
penne75423853_pen_ne
pennine93712953pennine
quinine163011043quinine
ravening122611293ravening
redefine1238973redefine
redline84218833redline
refine95225693_refine
reline65434353_reline
renin54830033_renin_
renins64526453_renins
repine85627813_repine
retine66237333_retine
rexine134719443_rexine
saddening1245213saddening
saponine1039223saponine
seine55732873_se_ine
senile63420213_senile
serine65432673_serine
sideline91011093sideline
sienite7312713sienite
stanine73417073stanine
syenite1039773syenite
taeniae739083taeniae
tapeline10310363tapeline
teniae64517353_teniae
theine94814923the_ine
uterine7315193uterine
valentine1245893valentine
vaseline1138613vaseline
venene92912523_venene
venin85118663_venin_
venines103516613_venines
venins93816703_venins
venire93513693_venire
wakening1636323wakening
weenie92612023weeni_e
weening114113973weening
widening13237833widening
wienie9229973wieni_e

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272616.43620824.6
3Display Results2612610.0932806.5
 (SQL Overall)1786912616.93525766.5
 
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.