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

295 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
aspect1061282(None) 
aspects1146741aspects
abject17137702abject
advect12309122advect
affect1448902affect
arpent84822092arpent
ascent84519652ascent
aspen75216092aspe_n
aspens85013352aspens
asper75520432aspe_r
aspers86220312aspers
aspic95114732aspic_
aspics104211562aspics
assent65119952assent
assert64922572assert
asset55932262asse_t
expect1758902expect
inspect1138462inspect
respect11412032respect
sect67443622_s_ect
spec85821972_spec_
speck135115652_speck
specs96916672_specs
spelt75430192_spelt
spent75532832_spent
suspect1158512suspect
abduct11108543abduct
abet610547943a_be_t
ablest84721833ablest
abreact11310823abreact
absent84016993absent
accent105116263accent
accept123210623accept
act59557843a___ct
addict10711203addict
adduct1087373adduct
adept81219643a_dept
advects13276013advects
advent102613753advent
advert103215773advert
affects1535393affects
afreet9315153afreet
agent65829643a_gent
aglet65534143agle_t
airest63825263airest
albeit8314343albeit
alec66430063a_lec_
alecs76620733a_lecs
alert54740653a_lert
alpaca1047383alpaca
ament76036543a_ment
amped104820513ampe_d
ampere10514413ampere
amplest11312333amplest
anapest9311553anapest
anent54931843a_nent
apace94718383a_pace
apart74330673a_part
ape57251183a_pe__
apeak115513453a_peak
aped78538153a_pe_d
apeek114711873a_peek
aper66336233a_pe_r
apercu1057383a_percu
apers76629133a_pers
apery106517903a_pery
apes66047433a_pe_s
apex137220213a_pe_x
apiece10510083apiece
aport75432173a_port
appeal103911613appeal
appear10379343appear
appel94615893appe_l
appels104312793appels
append1138273append
applet105917433applet
apse67725383apse__
apses76823913apse_s
apt57352543a_p__t
aptest82917513aptest
ardent73022613ardent
areca75618633a_reca
argent74023663argent
armet76739453arme_t
arpen74418043arpe_n
arpens84814823arpens
arpents93613083arpents
arrest63722633arrest
ascend9429733ascend
ascents93812553ascents
asci66519143as__ci
ascot76522513as_cot
asdic83814093asdic_
asdics9439863asdics
asea46327183as_e_a
ashed97829773ashe_d
ashen87818673ashe_n
ashes86230613ashe_s
ashiest10313953ashiest
askant10412713askant
asked106919313aske_d
asker96418783aske_r
askers105915403askers
askew12529413aske_w
aslant6317753aslant
asleep847283asleep
asp57235343asp___
aspectual1352773aspectual
asperate10312373asperate
asperity1347223asperity
asperse94210663asperse
asphalt1248083asphalt
aspire8612123aspire
aspis74618143asp_is
aspish114810333aspish
asps65622093asp__s
assents74512223assents
asserts74311793asserts
asses55629283asse_s
assess65710463assess
assets65617663assets
assist6314593assist
assort64916373assort
aster55434893aste_r
astern64815813astern
asters65631603asters
astrict9614783astrict
attent62818323attent
attest62618613attest
auspex1574793auspe_x
auspice1136523auspice
avert86029493a_vert
avocet11412683avocet
basest84720493bas_est
basilect1245903basilect
basket125722913baske_t
basset85225383basse_t
bassett94213863bassett
bisect10312873bisect
carpet104530093carpe_t
casket124820993caske_t
cathect1439863cathect
copeck1636943copeck
dampest12411043dampest
defect124816173defect
deject164512843deject
depict113514793depict
detect94217403detect
direct93817333direct
disject17268673disject
dissect103614133dissect
easiest72318773easiest
effect1437443effect
eject145016043_eject
elect74327033_elect
epact94921533_epact
erect74129333_erect
esprit8312843esprit
expects1866883expects
expert15515353expert
exsect1558503exsect
fastest102413723fastest
gashest114813413gashest
gasket114417253gaske_t
gasped104814293gaspe_d
gasper94515543gaspe_r
gaspers105014133gaspers
haslet93222713hasle_t
hasped125014443haspe_d
impact122310443impact
infect113413443infect
inject153210233inject
insect83916583insect
inspects1255863inspects
islet54527553isle_t
jasper154610383jaspe_r
jaspers164310463jaspers
jaspery19405253jaspery
kopeck1333423kopeck
lappet103817723lappe_t
nascent9610523nascent
object17135803object
obtect10129633obtect
pact86648723__pact
pandect12310953pandect
peat65967933__peat
pec76744413__pec_
pech116125453__pech
peck125730683__peck
pecs84634103__pecs
pelt67651083__pelt
pent66559073__pent
pert66759323__pert
pest65555293__pest
pet56477303__pe_t
pipet95533323pipe_t
prospect1447893prospect
rashest103916873rashest
rasped94715203raspe_d
rasper83917323raspe_r
raspers94415913raspers
raspiest10311273raspiest
refect114319333refect
reject154116283reject
repeat85127213repeat
repent84728873repent
resect84424703resect
respects1247703respects
respelt9312143respelt
ripest84317933ripest
safest95016603safest
sagest74920263sagest
samech13277033samech
sanest64426693sanest
sapient9415333sapient
sayest94217743sayest
scent75831623_scent
seat47575563_s_eat
sec55945323_s_ec_
secs65033893_s_ecs
sects75622893_s_ects
select82621173select
sent46963013_s_ent
sept65844363_s_ept
set36681253_s_e_t
sett45949053_s_ett
sext117338093_s_ext
sheet84836953_sheet
shent85933493_shent
skeet95429183_skeet
sleet55639133_sleet
slept75728103_slept
smelt74726783_smelt
sneck114713663_sneck
space95325673_space
spacy125415623_spacy
spait75631603_spait
spat66548523_sp_at
speak114618673_speak
spean74620513_spean
spear75821063_spear
specie10412223_specie
specks144312703_specks
specter113111733_specter
spectra11275833_spectra
spectre11297773_spectre
sped76031493_spe_d
speech1347563_speech
speed85526623_speed
speel74420763_speel
speer74623903_speer
speil75618643_speil
speir75315363_speir
spell75020303_spell
spelts84614643_spelts
speltz174010113_speltz
spence103813793_spence
spend85619333_spend
sperm93216013_sperm
spew95421873_spe_w
spews105015923_spews
spic85227433_spic_
spica94717943_spica
spice95528813_spice
spick134519073_spick
spics94123243_spics
spicy125417713_spicy
spilt75532223_spilt
spirt75032953_spirt
spit65545083_sp_it
splat76129343_splat
splent84720193_splent
split75729013_split
sport75935983_sport
spot65540683_sp_ot
spout75029633_spout
sprat76635973_sprat
sprent84522383_sprent
sprit76736403_sprit
spurt77227983_spurt
stent55634513_stent
stet45947323_ste_t
suet46754823_sue_t
suspects1254863suspects
sweat85628403_sweat
sweet85330523_sweet
swept105720603_swept
tappet103820113tappe_t
tasset65925313tasse_t
unpent83117373unpent
unspent92610893unspent
upsent83314063upsent
upset73222593upse_t
vastest102911513vastest
waspiest1338813waspiest

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162956.61017052.3
3Display Results2952950.0933172.0
 (SQL Overall)1786912956.84326113.0
 
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.