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) 
agnates82813181agnates
tannates81911951tannates
abates85825032a_bates
ablates92416902ablates
adnate72913482adnate_
aerates74627482aerates
agates76121332a_gates
agnate73314872agnate_
alates64833962a_lates
anankes1138762anankes
andantes9310852andantes
animates101316422animates
anlaces92313732anlaces
anlages82414102anlages
anlases72514902anlases
annals66415922anna_ls
annas55824882anna__s
annatto7144152annatto
annattos8133722annattos
annexes1437202annexes
annotates977292annotates
ansate64517862ansate_
ansated84214002ansated
antes56334322a_n_tes
aviates10313062aviates
donates83217222donates
enates64026422_enates
ingates82716892ingates
inmates92715762inmates
innages82911302innages
innate63917312innate_
magnates11511602magnates
mandates11314092mandates
mannites10312612mannites
nates55238332__nates
penates93321592penates
senates73322582senates
tannages9228962tannages
tannate71813522tannate_
wannabes1344472wannabes
abases85720773a_bases
abate76627843a_bate_
abated95918453a_bated
abater85518123a_bater
abaters95115193a_baters
abatis84317933a_batis
ablate82219213ablate_
ablated102513443ablated
abnegates1244943abnegates
abrades10312073abrades
abwatts1233403abwatts
acetates102013063acetates
acnes75922623acn__es
acnodes1037823acnodes
aconites10314343aconites
actuates10310303actuates
acuate8315633acuate_
acutes83917723a_cutes
acylates1339743acylates
adages8412953a_dages
addaxes1634573addaxes
adulates9311913adulates
aerate64830553aerate_
aerated85322373aerated
agapes95212413a_gapes
agate66525143a_gate_
agaves104611513a_gaves
agemates111110023agemates
agitates9310873agitates
agnails837003agnails
agnatic10310963agnatic
agnizes17328843agnizes
agrafes1137523agrafes
airdates939713airdates
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
angaries9314383angaries
angas65827983anga__s
angles74426703a_ngles
angsts738863angst_s
angulates10310853angulates
animate91617213animate_
animated111612373animated
animater101512393animater
animaters11129953animaters
animes84719593a_nimes
anises64826693a_nises
ankles104818383a_nkles
anklets114310413anklets
ankuses1148203ankuses
anlace82513923anlace_
anlage72514223anlage_
anlagen8238633anlagen
anlas55626933anla__s
anna45529013anna___
annal56520763anna__l
annalist8413753annalist
annealed936323annealed
annealer845503annealer
annealers944563annealers
anneals7449943anneals
annex12310883ann__ex
annexe1337813annexe_
annexed1535753annexed
annonas738793annonas
annotate877713annotate_
annotated1095613annotated
annoyed1185863annoyed
annoyer1095603annoyer
annoyers1185033annoyers
annoys967523ann_oys
annuals7388193annuals
annuities947463annuities
annulate8310923annulate_
annulated1038603annulated
annulet7311593annulet
annulets845813annulets
annuls64711733ann_uls
annulus7426613annulus
anoas57226493anoa__s
anodes74418753a_nodes
anoles64827423a_noles
anolytes11169203anolytes
anomies93316983anomies
ansae55720973ansa_e_
antae56828293anta_e_
antas55432033a_n_tas
ante46538903a_n_te_
anteater8311603anteater
anteaters939333anteaters
anted66328243a_n_ted
antedates1048603antedates
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
arsenates979363arsenates
ascites9312603ascites
ates45047923___ates
atlantes838553atlantes
atlases72410643atlases
atlatls744773atlatls
aubades1038743aubades
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
berates94126853berates
binate8419773binate_
borates94823013borates
bynames14256243bynames
canapes111213083canapes
cannabis1266033cannabis
cannas84518403canna__s
cannulates1247783cannulates
cantatas103410083cantatas
canulates11312863canulates
canvases13349513canvases
carates95630603carates
carnages11312213carnages
caseates10313703caseates
catenates11311803catenates
cates75951873__cates
caudates11310253caudates
cenotes92814543cenotes
cerates95428233cerates
cognates11311573cognates
comates114123633comates
conatus9310463conatus
connate9315753connate_
connotes10311453connotes
contes84432913con_tes
craniates11310653craniates
crates85736053_crates
creates95225173creates
curates95323823curates
cyanates13238423cyanates
dates65639153__dates
debates103718523debates
delates83526283delates
denotes83817003denotes
derates84028883derates
dilates83220653dilates
donate73619503donate_
donated93513863donated
dunites8313593dunites
dunnages10154933dunnages
dunnites947173dunnites
elates65032363_elates
eluates72014673eluates
emanates10311333emanates
enate54428143_enate_
encages103313783encages
encases93116053encases
endites83717063endites
endnotes945943endnotes
enfaces122110913enfaces
engages92912493engages
enlaces92313393enlaces
enrages83114853enrages
ensnares856893ensnares
entases72816273entases
equates162012313equates
ergates8314473ergates
estates74520173estates
fanfares1436773fanfares
fannies103415643fann_ies
fates85139233__fates
finales104016013finales
finites10315923finites
fixates1737383fixates
folates103218453folates
gahnites1235703gahnites
gallates92815523gallates
gannets83811443gannet_s
gates65939503__gates
gelates83219583gelates
gentes75324163gen_tes
gnats65217713_gnat_s
grates75429883_grates
gunites8313123gunites
gyrates113610263gyrates
hamates122917673hamates
handaxes1938403handaxes
hates86742573__hates
humates122813193humates
ideates8313723ideates
ignites81310573ignites
inanes62519803_inanes
incages103013883incages
incases93615973incases
incites93218483incites
indites83618983indites
infantes11249633infantes
infares10313023infares
inflates11512193inflates
ingate73018233ingate_
ingrates9514153ingrates
inhales10511863inhales
inlaces92512903inlaces
inmate82917353inmate_
innage73011573innage_
innards837153innards
innately1145613innately
innovates1245523innovates
insnares858083insnares
instates81615823instates
intakes11310943intakes
intonates9410233intonates
inundates1045773inundates
invades11118293invades
invites103915813invites
iodates8312893iodates
kainites1238793kainites
karates115617473karates
kentes105118643ken_tes
khanates1535733khanates
kinases113511123kinases
knaves13439523_knaves
knawes13328393_knawes
labiates101011513labiates
lactates10311223lactates
laminates112712903laminates
lanate6421263lanate_
lanated8313203lanated
lancinates1247153lancinates
legates82917673legates
lenites7818443lenites
ligates82318373ligates
linages8813173linages
locates93218813locates
lunate6316043lunate_
lunated8310823lunated
luxates1436973luxates
lysates10317473lysates
maenades1137473maenades
magnate10512703magnate_
malates93522603malates
maleates103316343maleates
manages103418963manages
manatee9317663manatee
manatees10310423manatees
manats84623463manat_s
mandate10315573mandate_
mandated12310283mandated
manganates1345943manganates
mannans93611523manna_ns
mannas85019803manna__s
mannite9312903mannite_
mannoses1039083mannoses
mantes84430783man_tes
marinates112516383marinates
mates75251363__mates
menaces112715523menaces
menages103615393menages
metates92720003metates
minutes93513433minutes
monades103713823monades
montes84226933mon_tes
mutates92215793mutates
nabes75427093__nabes
naiades838213naiades
names74833363__names
nanas55928633nana__s
nances83618643nan_ces
nancies93516843nancies
nannies73015203nannies
napes74828463__napes
nares55544153__nares
narrates8312753narrates
naves87030383__naves
neaten64214543_neaten
neatens73310403_neatens
neater64424313_neater
neatest72516003_neatest
neats55931903_neat_s
negates83215833negates
neonates8310063neonates
nidates8311883nidates
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
pennames12287783pennames
pennate93314033pennate_
pennated11299543pennated
phenates13611563phenates
phonates13410643phonates
pinatas93711483pinatas
pinites9319533pinites
pinnaces12268863pinnaces
pinnate93613743pinnate_
pinnated11338553pinnated
pirates93020323pirates
plates85432243_plates
pontes83627853pon_tes
prates84633163_prates
pronates10418373pronates
pupates113311433pupates
qanats154112813qanat_s
radiates92415293radiates
rates55352013__rates
rebates95123173rebates
redates83423863redates
relates73731423relates
remates93827103remates
renames92418053renames
rennases848983rennases
rentes65431193ren_tes
rotates72819773rotates
ruinates8311883ruinates
sanitates9611733sanitates
sates54949323__sates
satiates8314633satiates
savates10312953savates
sedates83418033sedates
senate63725143senate_
sensates8511133sensates
sinuates8310953sinuates
skates104219393_skates
slates64934063_slates
snakes103919603_snakes
snares65329033_snares
snathes104816493_snathes
snaths95112913_snaths
solates73523853solates
sonatas7510293sonatas
spates85028173_spates
stagnates1046733stagnates
stannites947013stannites
states64337083_states
tankages13217113tankages
tannage8209583tannage_
tates55444983__tates
tenaces92814513tenaces
tonnages9187873tonnages
tunnages9195903tunnages
unbales92914863unbales
unbated103317733unbated
uncages103213773uncages
uncakes133012743uncakes
uncases93516553uncases
uncrates10314553uncrates
undated93118463undated
uneases73316263uneases
uneaten7412543uneaten
ungated92717213ungated
unhats91110623unhat_s
unites65024853_unites
unlaces92513623unlaces
unlades82612833unlades
unmakes132810793unmakes
unmated103317023unmated
unnails738223unnails
unnamed102410273unnamed
unnoted8311363unnoted
unrated82621553unrated
unsated83419933unsated
unstates81314993unstates
updates10329793updates
uprates93814863uprates
urates65027763_urates
urinates8314133urinates
vacates12312833vacates
valuates112811193valuates
vanadates1345133vanadates
vantages12119023vantages
variates111214973variates
venenates1247573venenates
wannabe1234533wannabe_
wannabee1343993wannabee
wannabees1442213wannabees
wantages12109023wantages
xanthates1945653xanthates
yentes95517603yen_tes
zincates1937733zincates
zonate154114923zonate_
zonated173310533zonated

Search took 10 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.283631417.0
2DLD Change Limit1340274918.81015213.1
3Display Results4914910.1902584.2
 (SQL Overall)1786914919.28319249.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.