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

261 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
asses5562928(None) 
apses76823911apses
arses55733871arses
ashes86230611ashes
assess65710461assess
asset55932261asset
assets65617661assets
basses85428301basses
esses56422971esses
gasses75724781gasses
lasses64827591lasses
masses85028711masses
passes86030471passes
sasses64124391sasses
tasses64826761tasses
abases85720772abases
abbes96723522abbes
ables75935542ables
abuses85119102abuses
abyes105518532abyes
abysses1234862abysses
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
adzes155913802adzes
aedes64625152aedes
ages55844592a_ges
agues64919052agues
aides65336602aides
aisles64721142aisles
akees96119242akees
ales47067102a_les
almes75126542almes
aloes54933672aloes
amasses93912852amasses
amies76837692amies
amuses85117942amuses
anes45255932a_nes
anises64826692anises
antes56334322antes
anuses66218772anuses
apes66047432a_pes
apres75426402apres
apse67725382apse_
apsis75718292apsis
ares45871022a_res
arises65233802arises
arles56735742arles
arse46539272arse_
arsis55722422arsis
asceses938622asceses
ascus75013582ascus
asea46327182a_sea
asepses946362asepses
ashed97829772ashed
ashen87818672ashen
asides75118872asides
asked106919312asked
asker96418782asker
askers105915402askers
askeses1136462askeses
askew12529412askew
askos95011772askos
asks85721212a_sks
aspen75216092aspen
aspens85013352aspens
asper75520432asper
aspers86220312aspers
aspis74618142aspis
aspises9611642aspises
asps65622092a_sps
ass37844062a_s_s
assai5711542assai
assais6711962assais
assay8710282assay
assays977902assays
assent65119952assent
assents74512222assents
assert64922582assert
asserts74311792asserts
assist6314602assist
assizes1638452assizes
assumes967162assumes
assures7611402assures
aster55434892aster
asters65631602asters
ates45047922a_tes
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axises134413992axises
axles125219472axles
ayes76543512a_yes
baases85218012baases
bases75644352bases
bashes115631392bashes
basset85225382basset
bassets96414822bassets
bassos85313702bassos
bastes85330382bastes
beses75830722beses
biasses94911652biasses
bises75435622bises
bosses85925402bosses
brasses93818352brasses
buses75936012buses
busses85023382busses
carses85233652carses
cases75048382cases
cashes114729882cashes
cassis84818852cassis
castes85631862castes
causes88026472causes
cesses84221362cesses
chasses124017502chasses
classes94717942classes
coses76949492coses
cusses84522772cusses
daises74318982daises
dashes106124982dashes
dassies84418662dassies
disses75225962disses
doses65938502doses
dosses76126272dosses
eases56041612eases
easies64126632easies
erses55826802erses
eses45336102_eses
esnes54817362esnes
eyasses10388022eyasses
fasces114914542fasces
fashes124524022fashes
fesses94820252fesses
fosses96022082fosses
frasses104314512frasses
fuses85628422fuses
fusses94920552fusses
gases65633992gases
gashes105725152gashes
gassed85217632gassed
gasser75017772gasser
gassers84714632gassers
gausses8308692gausses
glasses84414272glasses
grasses84117342grasses
hanses95022632hanses
hashes125024802hashes
hassel95614212hassel
hassels104311022hassels
hassles103411692hassles
hastes95727072hastes
hawses125113992hawses
hisses94719352hisses
hoses85443182hoses
isles54220562isles
issei568572issei
isseis638562isseis
issues648802issues
jesses135215952jesses
josses135117682josses
kisses104217332kisses
kvasses14365502kvasses
lapses85217692lapses
lases54944762lases
lashes94831002lashes
lassies74420102lassies
lassis65216702lassis
lassoes74613852lassoes
lassos64913812lassos
leses54930812leses
loses56742012loses
losses65925232losses
lyses84518252lyses
manses84225512manses
marses84827112marses
mashes115030002mashes
massas85116462massas
masse75125292masse_
massed94421322massed
messes84924342messes
mises74740562mises
misses85130872misses
mosses85527682mosses
muses75134302muses
musses84624782musses
nesses64718322nesses
noses55435642noses
oases55330982oases
oses46641512_oses
parses85534702parses
pases75346502pases
pashes115828392pashes
passe75525692passe_
passed94320942passed
passee84522022passee
passel85117002passel
passels93913022passels
passer84721032passer
passers94717752passers
passus83610292passus
pastes85233912pastes
pauses84621472pauses
pisses84525082pisses
poses74642762poses
posses85128802posses
puses75532202puses
pusses84322842pusses
quasses16209502quasses
raises64826542raises
rases55447212rases
rashes95330152rashes
rassles73513922rassles
rises55244042rises
roses56445772roses
ruses56136582ruses
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sashes94728482sashes
sass45035622sas_s
sassed76116172sassed
sassies74719262sassies
sates54949322sates
saves85838632saves
saxes125229342saxes
sees45361052_sees
shes75734352_shes
sises55233832sises
sisses64520602sisses
sues46247652_sues
susses64221052susses
tasse54821842tasse_
tassel66014772tassel
tassels74510852tassels
tasset65925312tasset
tassets75012772tassets
tassies74918932tassies
tastes64126422tastes
tawses94913192tawses
tosses65225392tosses
trasses74819322trasses
tusses64921242tusses
uses44931112_uses
valses94514612valses
vases84626262vases
vises84427772vises
washes124425492washes
wastes96224882wastes
wises85633192wises
wisses94619602wisses
wrasses103812592wrasses
wusses93314892wusses
yeses85119322yeses
yesses93615812yesses

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.296603685.8
2DLD Change Limit538002611.47036598.6
3Display Results2612610.0763434.2
 (SQL Overall)1786912611.84297009.2
 
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.