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

495 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
adnate7291348(None) 
agnate73314881agnate
abate76627842a_bate
ablate82219212ablate
acuate8315632acuate
adage7414052ad_age
adulate8313232adulate
aduncate1145572aduncate
aerate64830552aerate
agate66525152a_gate
agnates82813192agnates
alate55340322a_late
andante8311272andante
annates72415422annates
ansate64517862ansate
antae56828292a_ntae
ante46538902a_n_te
aurate64426472aurate
aviate9315202aviate
binate8419772binate
date56443322_d_ate
donate73619502donate
enate54428152_enate
ideate7313682ideate
innate63917312innate
lanate6421262lanate
lunate6316042lunate
magnate10512702magnate
mandate10315572mandate
odonate848402odonate
ornate6315142ornate
radiate83416312radiate
senate63725172senate
tannate71813522tannate
zonate154114922zonate
abase76023483a_base
abated95918453a_bated
abater85518123a_bater
abates85825033a_bates
abdicate1348903abdicate
ablated102513443ablated
ablates92416903ablates
ablaze17239833ablaze
abnegate1144863abnegate
abrade9313053abrade
abwatt11410673abwatt
acerate92818913acerate
acetate92514753acetate
acne66625873acn__e
acnode938203acnode
aconite9315473aconite
actuate9311443actuate
acute74720363a_cute
acylate12310533acylate
adages8412953ad_ages
adapt81218553ad_apt
adapted1135843adapted
adapter1036173adapter
adapts9107813adapts
addable11218843addable
addax1435993adda_x
addaxes1634573addaxes
addle74318353ad_dle
adduce1076453adduce
adenine8311213adenine
adept81219643adept_
adepter1036113adepter
adepts9117103adepts
adequate1844303adequate
adhere10310333adhere
adit56443653ad_it_
adits66523713ad_its
adjure1435843adjure
adman84517903adma_n
admass957143admass
admire949933admire
admit8319493admit_
admits9411413admits
adnation9310783adnation
adnexa1433673adnexa
adnoun757033adnoun
adobe84814713ad_obe
adopt81219743adopt_
adopted1136253adopted
adoptee1048413adoptee
adopter1036763adopter
adopts998083adopts
adore65723673ad_ore
adoze155713833ad_oze
adulated1039753adulated
adulates9311913adulates
adult63520653adult_
adults7299953adults
adust64117453adust_
advance1346043advance
advice12107883advice
advise10139223advise
advocate1445833advocate
adyta936853ad_yta
adze1412820573ad__ze
aerated85322373aerated
aerates74627493aerates
aflame1138723aflame
agape85614843a_gape
agates76121343a_gates
agave95314033a_gave
agaze156113663a_gaze
agemate101210583agemate
agitate8312063agitate
aglare7312423aglare
agminate1139243agminate
agnail739533agnail
agnatic10310973agnatic
agnize16329563agnize
agrafe1038093agrafe
airdate8311323airdate
alae45643753a_la_e
alane56135613a_lane
alant55742293alant_
alants67722023alants
alated75625143a_lated
alates64833963a_lates
albata839333albata
albite8313313albite
alcade91111513alcade
algae65319623alga_e
alginate9310693alginate
alienate8311553alienate
alkane104313323alkane
alunite7311633alunite
amaze166016603a_maze
ambage11510603ambage
amirate91115953amirate
amniote936963amniote
ana39559833a_na__
anadem939183a_nadem
anal48037523a_na_l
analyte10158813a_nalyte
ananke1038283a_nanke
anas46649863a_na_s
anatase738943a_natase
anatto6139913a_natto
andantes9310853andantes
ane37866953a_n__e
anele55628833a_nele
angle64528873a_ngle
anile54634463a_nile
animate91617213animate
anime75423203a_nime
anise55129703a_nise
ankle95220253a_nkle
anlace82513923anlace
anlage72514233anlage
anna45529013anna__
annal56520763anna_l
annals66415923annals
annas55824883anna_s
annatto7144153annatto
annexe1337813annexe
annotate877713annotate
annulate8310923annulate
anode65021043a_node
anole55330383a_nole
ansae55720973a_nsae
ansated84214003ansated
ant37270793a_n_t_
anta46839583a_n_ta
antas55432033a_ntas
anted66328243a_n_ted
antes56334323a_n_tes
anti45536363a_n_ti
antre55224523a_ntre
ants47243473a_n_ts
aortae65115473aortae
apace94718383a_pace
apanage1036803apanage
aplite8316393aplite
aquae142212713aqua_e
arame75026623a_rame
arbute8311043arbute
arcade91013643arcade
arcane81216743arcane
arcuate9311963arcuate
areae55229743area_e
arenite71017713arenite
arete56031353a_rete
arhat8327093arhat_
arhats9312973arhats
arnatto7145073arnatto
arsenate81010483arsenate
astute6310763astute
ate37059243___ate
atlatl637873atlatl
aubade939223aubade
augite7312613augite
aunt46553653aun_t_
auntie64317703auntie
aunts55227633aun_ts
aunty85919813aun_ty
aurae54128113aura_e
aurated83817793aurated
aureate72515283aureate
avant86224663avant_
aviated11310263aviated
aviates10313063aviates
awake125014783a_wake
aware86420023a_ware
axite125218253a_xite
azote144416343a_zote
baccate131011263baccate
badinage1294923badinage
baldpate1345483baldpate
bandage11311023bandage
bandmate1347973bandmate
barbate11314543barbate
bate66552423__bate
bedmate1239433bedmate
bename103316073bename
berate84729023berate
blate75933783_blate
borate85026153borate
byname13256363byname
canape10913513canape
carate84734003carate
carinate103320243carinate
carnage10311743carnage
caseate9314783caseate
cate66254603__cate
catenate10312833catenate
caudate10311353caudate
cenote83715843cenote
cerate84829463cerate
coadunate1245643coadunate
cognate10312203cognate
comate104124843comate
connate9315753connate
conte76633203con_te
crate76537403_crate
create85126383create
crenate93317113crenate
cuneate9311723cuneate
curate85226243curate
cyanate12259703cyanate
dace76934923_d_ace
dacite91115883dacite
dale55643983_d_ale
damage10410773damage
dame77140313_d_ame
dance85223133dan_ce
dandle84218093dandle
dangle84119303dangle
dare55848863_d_are
data56026653_d_ata
dated75530993_d_ated
dater65332313_d_ater
dates65639153_d_ates
dato56129943_d_ato
daze147327233_d_aze
death94822523_death
deave95022333_deave
debate94419193debate
delate73827753delate
denote74118043denote
dentate8315153dentate
derate74531233derate
dilate73220693dilate
dite55547553_d_ite
doat56947673_doat_
doated84118183_doated
doats65224883_doats
donated93513863donated
donates83217223donates
dote55442883_d_ote
drake104918303_drake
drape85319633_drape
drat56247833_drat_
drats66628373_drats
drave95219273_drave
dunite7315013dunite
edentate947703edentate
educate10310213educate
elate55335883_elate
eluate62315433eluate
emanate9312473emanate
enates64026433_enates
endite73817593endite
endnote855743endnote
equate152012463equate
eradiate91911753eradiate
ergate7315143ergate
estate64719763estate
falcate12311613falcate
fate75444283__fate
faunae95210373fauna_e
finale94116763finale
finite9316823finite
fixate1638733fixate
folate93320393folate
gahnite1135973gahnite
galeate83916783galeate
gallate83417123gallate
gate55746573__gate
gelate73421253gelate
gladiate1057053gladiate
gnat56034433_gnat_
gnats65217713_gnats
gradate9511233grad_ate
graduate1058083graduate
grate64932883_grate
gunite7414403gunite
gyrate104912523gyrate
hamate113319833hamate
hastate10313913hastate
hate78450173__hate
headgate1346483headgate
headnote1245023headnote
humate113214443humate
hydrate14239813hydrate
ideated9310973ideated
ideates8313733ideates
ignite71410583ignite
inane52820343_inane
indite73520323indite
ingate73018243ingate
inmate82917363inmate
innage73011573innage
iodate7313503iodate
iodinate949343iodinate
irate55627983_irate
jadeite1546403jadeite
jugate14379463jugate
kainite1149543kainite
karate105320923karate
kente95821073ken_te
khanate1437073khanate
kinase104210653kinase
knave12389463_knave
knawe12397883_knawe
labiate91313573labiate
lactate9312693lactate
lacunate10128963lacunate
laminate103014633laminate
lanated8313203lanated
late47560483__late
legate72917453legate
lenite6719983lenite
ligate72519253ligate
linage7713403linage
lineate7815153lineate
lobate82915243lobate
locate83919843locate
lunated8310823lunated
luxate1338083luxate
lyrate94112103lyrate
lysate9388103lysate
madame1139853mad_ame
magnates11511613magnates
malate84624553malate
maleate94117543maleate
mammate104411273mammate
manage93818903manage
manat76039993manat_
manatee9317663manatee
manats84623463manats
mandated12310293mandated
mandates11314093mandates
mannite9312903mannite
marinate103017783marinate
mate65154223__mate
mediate103415213mediate
menace103216943menace
menage93216543menage
metate82720533metate
minae75627723mina_e
minute83414293minute
misate81222693misate
monte75829773mon_te
mutate83017483mutate
nabe66029493__nabe
nae35952743__na_e
name65637413__name
nape65230803__nape
narrate7313493narrate
nates55238333__nates
nave75732313__nave
negate72915573negate
neonate7311333neonate
nidate7313783nidate
nite45943583__nite
nonage7313683nonage
notate63217863notate
note46239963__note
nutate63017373nutate
oblate82214743oblate
odonates947743odonates
oleate6318883oleate
opiate8513463opiate
orate55133303_orate
ordinate9310253ordinate
outate62923403outate
ovate84214393_ovate
ozonate1646863ozonate
padnag1036073padna_g
padnags1135083padnags
paginate114012443paginate
palate84226783palate
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
pate65350463__pate
patinate103016313patinate
pawnage1335873pawnage
pedate93117763pedate
penates93321603penates
pennate93314033pennate
phenate12412193phenate
phonate12411813phonate
pinata83817223pinata
pinite8321243pinite
pinnate93613743pinnate
pirate82322883pirate
planate9314573planate
plate74635113_plate
prate75135983_prate
pronate9418873pronate
pupate104213123pupate
qanat144426843qanat_
qanats154112813qanats
quadrate1888043quadrate
quate144521413_quate
quinate16511573quinate
radiale83813523radiale
radiated102512593radiated
radiates92415293radiates
radicate11412873radicate
radwaste1243843radwaste
ramate83921683ramate
rate45458763__rate
rebate84424113rebate
redate74124683redate
relate64033633relate
remate84428683remate
rename82718813rename
rente54733783ren_te
rotate63320343rotate
rugate75813813rugate
ruinate7312833ruinate
saccate111311763saccate
sate45556103__sate
satiate7315403satiate
savate9313783savate
sedate73019813sedate
senates73322613senates
sensate7311893sensate
sente56432883sen_te
sinuate7412163sinuate
skate94721553_skate
slate55438283_slate
snake94821113_snake
snare54429983_snare
snath86419803_snath
snathe94415113_snathe
solate64526073solate
sonata6313223sonata
spate74731583_spate
spinate93114813spinate
stagnate947243stagnate
state56237333_state
tannage8209583tannage
tannates81911953tannates
tate44748603__tate
tenace82715693tenace
ternate7415483ternate
togate74515683togate
tubate82813173tubate
ulnae55214573ulna_e
undated93118463undated
unite54828383_unite
update93810293update
uprate83916543uprate
urate55432163_urate
urinate7315363urinate
vacate11314553vacate
vaginate123911083vaginate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variate101316433variate
velate93720143velate
venae85920983vena_e
wannabe1234533wannabe
yente86220043yen_te
zincate1838533zincate
zonae145116443zona_e
zonated173310533zonated

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.376475242.0
2DLD Change Limit1127164956.21618133.2
3Display Results4954950.1563173.1
 (SQL Overall)1786914956.74826480.6
 
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.