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

237 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
anted6632824(None) 
acted88521731acted
ante46538901ante_
anteed75616111anteed
antes56334321antes
canted94825781canted
hanted104124311hanted
panted95024821panted
ranted74324701ranted
wanted104319721wanted
aahed917816442aahed
abated95918452abated
abed79734132a_bed
abled86926832abled
aced79540882a_ced
ached119227832ached
acned87520672acned
acred87126352acred
added84918432added
adzed166012542adzed
after85719792after
aged67334252a_ged
agented939422agented
ahed89536252a_hed
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
airted74214502airted
alated75625152alated
alter54828502alter
amped104820512amped
and47244172an__d
ane37866952an_e_
aneled74719282aneled
anes45255932an_es
anew76623132an_ew
angel65019572angel
anger66225882anger
angled84219092angled
ankled114313482ankled
annex12310882annex
anode65021042anode
ansated84214002ansated
ant37270792ant__
anta46839582ant_a
antae56828292antae
antas55432032antas
anthem113410342anthem
anther93715062anther
anti45536362ant_i
antic75728862antic
antired82316192antired
antis55033312antis
antler64615552antler
antra56521922antra
antre55224522antre
antres65021002antres
ants47243472ant_s
antsy85712792antsy
aped78538152a_ped
apter76120202apter
arced88224162arced
armed86324432armed
artel56122742artel
ashed97829772ashed
asked106919312asked
aster55434892aster
ate37059242a_te_
ates45047922a_tes
attend7258972attend
autoed7712822autoed
awed88436032a_wed
awned96615952awned
axed128829612a_xed
axled135315812axled
azoted16388592azoted
baited95319242baited
banded105223172banded
baned85436352ban_ed
banged104923732banged
banked135021442banked
banned94721342banned
banter84825332banter
basted95227232basted
bated85935532bated
batted95623652batted
bunted95219182bunted
caned85838092can_ed
canned95022062canned
canoed94618962canoed
canter85230112canter
carted98631442carted
catted95422472catted
chanted134015952chanted
cited84421952cited
coted85033852coted
danced105315252danced
danged94819492danged
darted84620922darted
dated75530992dated
daunted93810192daunted
dauted84114932dauted
dawted11489682dawted
dented84120512dented
dinted84419842dinted
doted75227072doted
dunted84718502dunted
ended74421262ended
enter54726382enter
fainted114211722fainted
fanged114318232fanged
fanned104117472fanned
fantod102010032fantod
farted105121782farted
fasted105320952fasted
fated95632132fated
fatted105419842fatted
feted94420932feted
gaited84416922gaited
ganged94619202ganged
gasted84821582gasted
gated75329772gated
granted94715102granted
hafted134713832hafted
halted105019602halted
handed114919982handed
hanged114222402hanged
hanked144220602hanked
hasted105125282hasted
hated95734022hated
hatted104921512hatted
haunted11399732haunted
hented104218752hented
hinted104318322hinted
hunted104417012hunted
inked104218522inked
inned64118422inned
intend72310372intend
inter55028492inter
jaunted15418562jaunted
kited105120092kited
kneed104612052kneed
lanated8313202lanated
lanced93717722lanced
landed84619242landed
lasted74323602lasted
lated65240672lated
linted74021822linted
lunted74517522lunted
luted64826142luted
malted94819862malted
maned86634102man_ed
manned94418642manned
mantel84317972mantel
mantes84430782mantes
mantid93820382mantid
mantled104113392mantled
marted94425212marted
masted94025802masted
mated85537782mated
matted94521412matted
meted85424432meted
minted94220582minted
muted85023382muted
naked105320852naked
naled65525052naled
named85223062named
nates55238332nates
need54934152_need
noted65123842noted
opted84914272opted
outed65429062outed
painted104214632painted
paned85437182pan_ed
panged104722342panged
panned94123432panned
parted94228682parted
pasted94426902pasted
pated85237842pated
patted94724682patted
planted103516122planted
punted94618712punted
quanted1738962quanted
rafted104714702rafted
ranged84824322ranged
ranked114620742ranked
ranter63826822ranter
rated65441382rated
ratted74923342ratted
rented74426592rented
sainted84114242sainted
salted74121202salted
sanded84920612sanded
saned65636272san_ed
sated66238532sated
sauted74119602sauted
scanted104114392scanted
sited65130742sited
slanted83514742slanted
sned56026052sn_ed
tainted83512422tainted
tanged84622512tanged
tanked113919302tanked
tanned75219962tanned
tarted74923372tarted
tasted74123972tasted
tatted74920532tatted
taunted84310962taunted
tauted75317112tauted
ted46446562__ted
tented74221002tented
tinted74419532tinted
toted64929482toted
unfed94614222unfed
united74421542united
unled64021072unled
untied73720812untied
unwed94114872unwed
vaned94622422van_ed
vanned104614482vanned
vatted104214732vatted
vaunted11438862vaunted
vented104617922vented
voted93919142voted
wafted134012142wafted
waited103819772waited
waned95831782wan_ed
wanked144517152wanked
wanned104318012wanned
wanter94423052wanter
warted104223232warted
wasted104423022wasted
wited94727142wited
wonted103213282wonted
wyted12529472wyted
yanked144312242yanked

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 Filter178691538000.343520965.0
2DLD Change Limit538002375.07610598.9
3Display Results2372370.1401692.9
 (SQL Overall)1786912375.55932144.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.