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

491 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
annates7241542(None) 
agnates82813191agnates
tannates81911951tannates
abates85825032a_bates
ablates92416902ablates
adnate72913482adnate_
aerates74627492aerates
agates76121342a_gates
agnate73314882agnate_
alates64833962a_lates
anankes1138762anankes
andantes9310852andantes
animates101316422animates
anlaces92313732anlaces
anlages82414112anlages
anlases72514902anlases
annals66415922anna_ls
annas55824882anna__s
annatto7144152annatto
annattos8133722annattos
annexes1437202annexes
annotates977292annotates
ansate64517862ansate_
ansated84214002ansated
antes56334322a_n_tes
aviates10313062aviates
donates83217222donates
enates64026422_enates
ingates82716912ingates
inmates92715782inmates
innages82911302innages
innate63917312innate_
magnates11511612magnates
mandates11314092mandates
mannites10312612mannites
nates55238332__nates
penates93321592penates
senates73322582senates
tannages9228962tannages
tannate71813522tannate_
wannabes1344472wannabes
abases85720773a_bases
abate76627843a_bate_
abated95918453a_bated
abater85518123a_bater
abaters95115203a_baters
abatis84317933a_batis
ablate82219213ablate_
ablated102513443ablated
abnegates1244943abnegates
abrades10312073abrades
abwatts1233403abwatts
acetates102013063acetates
acnes75922623acn__es
acnodes1037833acnodes
aconites10314353aconites
actuates10310313actuates
acuate8315633acuate_
acutes83917723a_cutes
acylates1339743acylates
adages8412953a_dages
addaxes1634573addaxes
adulates9311913adulates
aerate64830553aerate_
aerated85322373aerated
agapes95212413a_gapes
agate66525153a_gate_
agaves104611513a_gaves
agemates111110023agemates
agitates9310883agitates
agnails837003agnails
agnatic10310973agnatic
agnizes17328843agnizes
agrafes1137523agrafes
airdates939723airdates
alants67722023alant_s
alate55340323a_late_
alated75625143a_lated
albatas938373albatas
albites9313203albites
alcades101011473alcades
alginates10310123alginates
aliases7914493aliases
alienates9310683alienates
alkanes113812933alkanes
alunites8310703alunites
amazes175613473a_mazes
ambages1269623ambages
amirates101114793amirates
amniotes1036603amniotes
anabas8314083a_nabas
anabases1038083anabases
anadem939183a_nadem
anadems1036143a_nadems
analytes11169203analytes
ananke1038283ananke_
anapest9311553a_napest
anas46649863a_na__s
anatase738943a_natase
anatases839793anatases
anatto6139913a_natto
anattos7138453anattos
ancones93116343ancones
andante8311273andante_
aneared8512743aneared
anears63717183anea_rs
aneles64626293a_neles
anes45255933a_n__es
angaries9314393angaries
angas65827983anga__s
angles74426703a_ngles
angsts738863angst_s
angulates10310863angulates
animate91617213animate_
animated111612373animated
animater101512393animater
animaters11129973animaters
animes84719593a_nimes
anises64826693a_nises
ankles104818383a_nkles
anklets114310413anklets
ankuses1148203ankuses
anlace82513923anlace_
anlage72514233anlage_
anlagen8238643anlagen
anlas55626933anla__s
anna45529013anna___
annal56520763anna__l
annalist8413753annalist
annealed936343annealed
annealer845503annealer
annealers944563annealers
anneals7449943anneals
annex12310883ann__ex
annexe1337813annexe_
annexed1535753annexed
annonas738793annonas
annotate877713annotate_
annotated1095613annotated
annoyed1185873annoyed
annoyer1095603annoyer
annoyers1185033annoyers
annoys967523ann_oys
annuals7388193annuals
annuities947463annuities
annulate8310923annulate_
annulated1038603annulated
annulet7311593annulet
annulets845813annulets
annuls64711733ann_uls
annulus7426613annulus
anoas57226493anoa__s
anodes74418763a_nodes
anoles64827433a_noles
anolytes11169213anolytes
anomies93316993anomies
ansae55720973ansa_e_
antae56828293anta_e_
antas55432033a_n_tas
ante46538903a_n_te_
anteater8311603anteater
anteaters939343anteaters
anted66328243a_n_ted
antedates1048613antedates
antis55033313a_n_tis
antres65021003a_ntres
ants47243473a_n_t_s
anuses66218773a_nuses
apanages1137013apanages
aplites9314933aplites
arames84622573a_rames
arbutes939703arbutes
arcades101113193arcades
arenites8917103arenites
aretes64425353a_retes
arhats9312973arhat_s
arnatto7145073arnatto
arnattos8144363arnattos
arrases71214543arrases
arsenates979373arsenates
ascites9312603ascites
ates45047923___ates
atlantes838553atlantes
atlases72410643atlases
atlatls744773atlatls
aubades1038753aubades
augites8312183augites
aunties73920073aunties
aunts55227633aun_t_s
aurate64426473aurate_
aurated83817793aurated
avgases11106313avgases
aviate9315203aviate_
aviated11310263aviated
awakes135012473a_wakes
axites134913833a_xites
azotes154312223a_zotes
bandages12310633bandages
bandmates1447923bandmates
banjaxes2443393banjaxes
banknotes1544313banknotes
bannets94013843bannet_s
bates75846343__bates
benames112814603benames
berates94126873berates
binate8419773binate_
borates94823013borates
bynames14256243bynames
canapes111213083canapes
cannabis1266033cannabis
cannas84518403canna__s
cannulates1247783cannulates
cantatas103410093cantatas
canulates11312873canulates
canvases13349513canvases
carates95630613carates
carnages11312213carnages
caseates10313713caseates
catenates11311813catenates
cates75951893__cates
caudates11310263caudates
cenotes92814543cenotes
cerates95428253cerates
cognates11311583cognates
comates114123643comates
conatus9310463conatus
connate9315753connate_
connotes10311453connotes
contes84432913con_tes
craniates11310653craniates
crates85736063_crates
creates95225203creates
curates95323833curates
cyanates13238433cyanates
dates65639153__dates
debates103718533debates
delates83526283delates
denotes83817003denotes
derates84028893derates
dilates83220663dilates
donate73619503donate_
donated93513863donated
dunites8313593dunites
dunnages10154933dunnages
dunnites947173dunnites
elates65032363_elates
eluates72014683eluates
emanates10311333emanates
enate54428143_enate_
encages103313783encages
encases93116053encases
endites83717063endites
endnotes945943endnotes
enfaces122110913enfaces
engages92912493engages
enlaces92313393enlaces
enrages83114853enrages
ensnares856893ensnares
entases72816273entases
equates162012323equates
ergates8314493ergates
estates74520183estates
fanfares1436773fanfares
fannies103415643fann_ies
fates85139233__fates
finales104016013finales
finites10315923finites
fixates1737393fixates
folates103218453folates
gahnites1235703gahnites
gallates92815523gallates
gannets83811443gannet_s
gates65939513__gates
gelates83219583gelates
gentes75324163gen_tes
gnats65217713_gnat_s
grates75429893_grates
gunites8313123gunites
gyrates113610263gyrates
hamates122917683hamates
handaxes1938403handaxes
hates86742573__hates
humates122813193humates
ideates8313733ideates
ignites81310583ignites
inanes62519803_inanes
incages103013883incages
incases93615973incases
incites93218483incites
indites83618983indites
infantes11249633infantes
infares10313023infares
inflates11512193inflates
ingate73018243ingate_
ingrates9514173ingrates
inhales10511863inhales
inlaces92512903inlaces
inmate82917363inmate_
innage73011573innage_
innards837153innards
innately1145613innately
innovates1245523innovates
insnares858083insnares
instates81615833instates
intakes11310943intakes
intonates9410243intonates
inundates1045773inundates
invades11118293invades
invites103915813invites
iodates8312903iodates
kainites1238793kainites
karates115617473karates
kentes105118643ken_tes
khanates1535733khanates
kinases113511123kinases
knaves13439523_knaves
knawes13328393_knawes
labiates101011513labiates
lactates10311223lactates
laminates112712903laminates
lanate6421263lanate_
lanated8313203lanated
lancinates1247153lancinates
legates82917683legates
lenites7818443lenites
ligates82318383ligates
linages8813173linages
locates93218813locates
lunate6316043lunate_
lunated8310823lunated
luxates1436973luxates
lysates10317473lysates
maenades1137473maenades
magnate10512703magnate_
malates93522603malates
maleates103316343maleates
manages103418963manages
manatee9317663manatee
manatees10310423manatees
manats84623463manat_s
mandate10315573mandate_
mandated12310293mandated
manganates1345953manganates
mannans93611523manna_ns
mannas85019803manna__s
mannite9312903mannite_
mannoses1039083mannoses
mantes84430783man_tes
marinates112516383marinates
mates75251363__mates
menaces112715523menaces
menages103615393menages
metates92720013metates
minutes93513443minutes
monades103713823monades
montes84226933mon_tes
mutates92215793mutates
nabes75427093__nabes
naiades838213naiades
names74833363__names
nanas55928633nana__s
nances83618643nan_ces
nancies93516843nancies
nannies73015203nannies
napes74828463__napes
nares55544153__nares
narrates8312763narrates
naves87030383__naves
neaten64214543_neaten
neatens73310403_neatens
neater64424313_neater
neatest72516003_neatest
neats55931903_neat_s
negates83215843negates
neonates8310063neonates
nidates8311893nidates
nites55736343__nites
nonages8313843nonages
notates72817483notates
notes55034583__notes
nutates73214973nutates
oblates91913243oblates
odonates947743odonates
oleates7417833oleates
opiates9312143opiates
orates64328613_orates
ornate6315133ornate_
ozonates1745963ozonates
paginates123111363paginates
palates93624933palates
palpates122613063palpates
pancakes1637073pancakes
pannes85522853pann__es
pates76047893__pates
patinates113814693patinates
pawnages1435313pawnages
pennames12287793pennames
pennate93314033pennate_
pennated11299543pennated
phenates13611573phenates
phonates13410643phonates
pinatas93711503pinatas
pinites9319533pinites
pinnaces12268863pinnaces
pinnate93613743pinnate_
pinnated11338553pinnated
pirates93020333pirates
plates85432243_plates
pontes83627853pon_tes
prates84633163_prates
pronates10418373pronates
pupates113311433pupates
qanats154112813qanat_s
radiates92415293radiates
rates55352013__rates
rebates95123183rebates
redates83423873redates
relates73731433relates
remates93827113remates
renames92418053renames
rennases848983rennases
rentes65431193ren_tes
rotates72819773rotates
ruinates8311883ruinates
sanitates9611733sanitates
sates54949323__sates
satiates8314633satiates
savates10312953savates
sedates83418033sedates
senate63725143senate_
sensates8511133sensates
sinuates8310963sinuates
skates104219403_skates
slates64934063_slates
snakes103919603_snakes
snares65329033_snares
snathes104816493_snathes
snaths95112913_snaths
solates73523853solates
sonatas7510293sonatas
spates85028173_spates
stagnates1046733stagnates
stannites947023stannites
states64337083_states
tankages13217113tankages
tannage8209583tannage_
tates55444983__tates
tenaces92814513tenaces
tonnages9187873tonnages
tunnages9195903tunnages
unbales92914863unbales
unbated103317733unbated
uncages103213773uncages
uncakes133012743uncakes
uncases93516553uncases
uncrates10314563uncrates
undated93118463undated
uneases73316263uneases
uneaten7412543uneaten
ungated92717213ungated
unhats91110623unhat_s
unites65024853_unites
unlaces92513623unlaces
unlades82612833unlades
unmakes132810793unmakes
unmated103317023unmated
unnails738223unnails
unnamed102410273unnamed
unnoted8311363unnoted
unrated82621553unrated
unsated83419933unsated
unstates81314993unstates
updates10329793updates
uprates93814863uprates
urates65027763_urates
urinates8314133urinates
vacates12312833vacates
valuates112811203valuates
vanadates1345133vanadates
vantages12119023vantages
variates111214983variates
venenates1247583venenates
wannabe1234533wannabe_
wannabee1343993wannabee
wannabees1442213wannabees
wantages12109023wantages
xanthates1945653xanthates
yentes95517603yen_tes
zincates1937743zincates
zonate154114923zonate_
zonated173310533zonated

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 Limit1340274916.92019368.1
3Display Results4914910.1862639.8
 (SQL Overall)1786914917.26624592.8
 
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.