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

178 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
ashed9782977(None) 
aahed917816441aahed
ached119227831ached
ahed89536251a_hed
ashen87818671ashen
ashes86230611ashes
asked106919311asked
bashed126225701bashed
cashed125124351cashed
dashed115920561dashed
fashed136720251fashed
gashed116321971gashed
hashed136021941hashed
lashed105625211lashed
mashed125325041mashed
pashed125923141pashed
sashed105622941sashed
shed86536151_shed
washed135521501washed
abashed1357662abashed
abed79734132a_bed
abled86926832abled
aced79540882a_ced
ache96829822ache_
aches106132292aches
acned87520662acned
acred87126352acred
acted88521732acted
added84918432added
adzed166012542adzed
aged67334252a_ged
ahead96817052a_head
ahem97225362a_hem
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
airshed11258532airshed
aisled74516182aisled
amped104820512amped
anted66328242anted
aped78538152a_ped
aphid115515392aphid
arced88224162arced
arched125717322arched
armed86324432armed
ascend9429732ascend
asea46327182as_ea
ash67944602ash__
ashamed1336242ashamed
ashier94714832ashier
ashler9459972ashler
ashmen1168172ashmen
ashy107717352ash_y
aside65122082aside
asker96418782asker
askew12529412askew
aspen75216092aspen
asper75520432asper
asses55629282asses
asset55932262asset
aster55434892aster
awed88436032a_wed
awned96615952awned
axed128829612a_xed
axled135315812axled
axseed1456992axseed
bached145519892bached
based85331582bas_ed
basher115123812basher
bashes115631392bashes
basked135218602basked
basted95227232basted
bathed125518742bathed
bushed124822382bushed
cached145419202cached
cased86032412cas_ed
cashes114729882cashes
cashew144311452cashew
casked134815512casked
clashed133614012clashed
coshed124217542coshed
crashed134214202crashed
dasher104318982dasher
dashes106124982dashes
deashed123411302deashed
dished114318712dished
eased65430402eas_ed
eched116919222eched
fashes124524022fashes
fasted105320952fasted
fished134316312fished
flashed144112182flashed
gasher104320372gasher
gashes105725152gashes
gasped104814292gasped
gassed85217632gassed
gasted84821582gasted
gnashed12317522gnashed
gushed114816242gushed
hashes125024802hashes
hasped125014442hasped
hasted105125282hasted
hushed134416672hushed
isled64615992isled
joshed174610902joshed
kasher134915032kasher
lased65132342las_ed
lasher94824532lasher
lashes94831002lashes
lasted74323602lasted
lathed104718452lathed
leashed113211162leashed
lushed104218722lushed
masher114123202masher
mashes115030002mashes
masked134316522masked
massed94421322massed
masted94025802masted
meshed124415932meshed
moshed124517492moshed
mushed124420842mushed
noshed104413502noshed
ohed87825182_ohed
oohed94214212oohed
pashes115828392pashes
passed94320942passed
pasted94426902pasted
pished124817062pished
plashed133712642plashed
pushed125017462pushed
quashed20207972quashed
rased65033932ras_ed
rasher95024112rasher
rashes95330152rashes
rasped94715202rasped
rushed104419862rushed
sabed86526812sabed
saned65636272saned
sashes94728482sashes
sassed76116172sassed
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
seed55549482_seed
shad86230912_shad
she66837692_she_
shea76031572_shea
sheds96122702_sheds
shend94719972_shend
sherd96321152_sherd
shes75734352_shes
shew108030762_shew
shied96125492_shied
shod86225052_shod
shoed95723002_shoed
shred98125612_shred
slashed114114852slashed
sled55334372_sled
smashed133711222smashed
sned56026052_sned
sped76031492_sped
stashed113812482stashed
sued56537932_sued
swashed144311362swashed
tasked114714642tasked
tasted74123972tasted
trashed113514692trashed
tsked105910032tsked
tushed104615892tushed
unshed10313772unshed
used55722822us_ed
usher84517762usher
washer124720392washer
washes124425492washes
wasted104423022wasted
wished134417512wished

Search took 2 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.0802233637.5
2DLD Change Limit538001781.73331044.4
3Display Results1781780.0632825.4
 (SQL Overall)1786911781.87695251.1
 
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.