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 “ante” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

268 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
ante4653890(None) 
ane37866941an_e
ant37270781ant_
anta46839581anta
antae56828291antae
anted66328241anted
antes56334321antes
anti45536361anti
antre55224521antre
ants47243471ants
ate37059241a_te
abate76627842abate
abbe87627182abbe
abet610547942abet
able66340532able
abye97921002abye
ace59656832a_ce
ache96829822ache
acme86924322acme
acne66625872acne
acre67330772acre
act59557842act_
acta69524802acta
acted88521732acted
acts66929862acts
acute74720362acute
adnate72913482adnate
adze1412820572adze
ae212590292a__e
aft66849012aft_
after85719792after
agate66525142agate
age47154332a_ge
agee56241492agee
agnate73314872agnate
ague55725922ague
aide56044992aide
ait38093902ait_
aits46355532aits
ajee115928232ajee
akee85936812akee
alae45643752alae
alate55340322alate
ale36572342a_le
alee46652322alee
alme65832162alme
aloe45540192aloe
alt36467962alt_
alter54828502alter
alto47831262alto
alts46639902alts
amie66339842amie
an211879072an__
ana39559822an_a
anal48037522anal
anas46649862anas
and47244162an_d
ands57833612ands
anele55628832anele
anes45255932anes
anew76623132anew
anga56831352anga
angel65019562angel
anger66225872anger
angle64528872angle
ani37751172an_i
anil46437432anil
anile54634462anile
anime75423202anime
anis45746462anis
anise55129702anise
ankh111114412ankh
ankle95220252ankle
anna45529012anna
annex12310882annex
anoa45634472anoa
anode65021032anode
anole55330372anole
anon46134852anon
ansa45927772ansa
ansae55720972ansae
ansate64517862ansate
antas55432032antas
anteed75616112anteed
anthem113410342anthem
anther93715062anther
antic75728862antic
antis55033312antis
antler64615552antler
antra56521922antra
antres65021002antres
antsy85712792antsy
anus47131112anus
any68440482an_y
ape57251182a_pe
apse67725382apse
apt57352542apt_
apter76120202apter
are37874572a_re
arete56031352arete
arse46539272arse
art38679142art_
artel56122742artel
arts49650262arts
arty77531312arty
aster55434892aster
at212393402a_t_
ates45047922a_tes
att35454652a_tt
aunt46553652aunt_
auntie64317702auntie
aunts55227632aunts
aunty85919812aunty
auto47432082auto
ave67748702a_ve
awe67746622a_we
awee76336642awee
axe108239492a_xe
axite125218252axite
axle116424602axle
aye67151762a_ye
azote144416342azote
bane65250422ban_e
banter84825332banter
banty106624002banty
baste74829982baste
bate66552422bate
bite66546992bite
bute66739672bute
byte96521812byte
cane66653112can_e
canoe75627252canoe
cant66362022cant_
canted94825782canted
canter85230112canter
cantle84522152cantle
canto74931012canto
cants77036942cants
canty105226802canty
carte75940422carte
caste75932362caste
cate66254592cate
cete64934782cete
cite65640342cite
conte76633202conte
cote66648732cote
cute66440452cute
dance85223132dance
date56443322date
dite55547552dite
dote55442882dote
enate54428142enate
enter54726382enter
fane75343562fan_e
fate75444282fate
fete75734922fete
gane55145292gan_e
gate55746572gate
gite55438612gite
hance105424152hance
hanse85722792hanse
hant75461582hant_
hanted104124312hanted
hantle94318202hantle
hants86335402hants
haste85927862haste
hate78450172hate
haute89521612haute
hyte109018942hyte
inter55028492inter
inti46626072inti
into45026152into
jane115031472jan_e
janty156816962janty
jete115927252jete
jute115327892jute
kane85133962kan_e
kente95821062kente
kite85338232kite
knee85323602knee
kyte117017762kyte
lanate6421262lanate
lance75126722lance
lane45153322lan_e
late47560482late
latte55426302latte
lite47054542lite
lute46341012lute
mane65052012man_e
mange84930182mange
manse75528222manse
manta75629902manta
mantel84317972mantel
mantes84430782mantes
mantle84420922mantle
mate65154212mate
matte75626842matte
mete64438132mete
mite66249402mite
monte75829772monte
mote67048082mote
mute65136872mute
nabe66029492nabe
nae35952742_nae
name65637412name
nance74721842nance
nape65230802nape
nates55238332nates
nave75732312nave
ne27045102_n_e
nee36657782_nee
net36670292_net
nite45943582nite
note46239962note
nth66320592_nth
once65423082once
one37050912on_e
onto46127662onto
pane64950282pan_e
panne76623652panne
pant66061252pant_
panted95024822panted
pantie84326472pantie
panto76129412panto
pants76536922pants
panty105929302panty
paste74932952paste
pate65350462pate
rance75028512rance
ranee55438102ranee
range64728412range
rant45864672rant_
ranted74324702ranted
ranter63826822ranter
rants55935342rants
rate45458762rate
rente54733782rente
rete44944132rete
rite45849452rite
rote46249022rote
sane45954332san_e
santo56227282santo
sate45556102sate
saute55028082saute
sente56432872sente
site47052412site
snye77115492snye
tanto55724942tanto
taste55127232taste
tate44748602tate
tote46643672tote
unbe65319272unbe
unde55825482unde
unite54828382unite
untie54425492untie
unto45824282unto
ute35335882_ute
vane75534682van_e
vote74728622vote
wane76344712wan_e
want76156162want_
wanted104319722wanted
wanter94423052wanter
wants87932212wants
waste86125052waste
wite75443272wite
wyte106018642wyte
yente86220042yente

Search took 3 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 Filter178691298720.203880251.2
2DLD Change Limit298722682.11014157.3
3Display Results2682680.1401914.3
 (SQL Overall)1786912682.45372845.9
 
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.