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

173 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
esses5642297(None) 
asses55629281asses
cesses84221361cesses
eases56041611eases
erses55826801erses
eses45336101e_ses
esnes54817361esnes
fesses94820251fesses
jesses135215951jesses
messes84924341messes
nesses64718321nesses
yesses93615811yesses
apses76823912apses
arses55733872arses
ashes86230612ashes
assess65710462assess
asset55932262asset
assets65617662assets
bases75644352bases
basses85428302basses
beses75830722beses
bises75435622bises
blesses93812392blesses
bosses85925402bosses
buses75936012buses
busses85023382busses
cases75048382cases
ceases84427072ceases
censes83721802censes
cessed94615612cessed
chesses124112632chesses
coses76949492coses
cresses94219812cresses
cusses84522772cusses
disses75225962disses
doses65938502doses
dosses76126272dosses
dresses83716172dresses
ease45042332ease_
eased65430402eased
easel54521112easel
easels65914552easels
easies64126632easies
easts57530322easts
eaves85231992eaves
eches106322162eches
edges75718722edges
egises7312492egises
ekes86726602e_kes
else45923082else_
elves85118742elves
emes65434662e_mes
emeses86114962emeses
ensues63313812ensues
epees75219832epees
eposes84418782eposes
erases64425402erases
ernes55224812ernes
eroses65327052eroses
esker94412982esker
eskers105312222eskers
esne47018792esne_
espies83716802espies
ess36030882e_s_s
essay867622essay
essays965652essays
ester54727712ester
esters64627732esters
eves76230462e_ves
ewes76328702e_wes
exes116530812e_xes
eyases94513682eyases
eyasses10388022eyasses
eyes75837882e_yes
eyres84921772eyres
feases95422922feases
fesse86116332fesse_
fessed104515062fessed
fosses96022082fosses
fuses85628422fuses
fusses94920552fusses
gases65633992gases
gasses75724782gasses
gessoes838292gessoes
gestes75721392gestes
guesses8169372guesses
hisses94719352hisses
hoses85443172hoses
isles54220562isles
issei568572issei
isseis638562isseis
issues648802issues
jesse126012832jesse_
jessed144112302jessed
josses135117682josses
kisses104217332kisses
lases54944762lases
lasses64827592lasses
leases65428112leases
lenses64620892lenses
leses54930812leses
lessee64116362lessee
lessees73510242lessees
lessen64212432lessen
lessens7409382lessens
lesser63514852lesser
loesses7310032loesses
loses56742012loses
losses65925232losses
lyses84518252lyses
masses85028712masses
menses84222452menses
meshes115019442meshes
mesnes85216212mesnes
messed95018182messed
mises74740562mises
misses85130872misses
mosses85527682mosses
muses75134302muses
musses84624782musses
noses55435642noses
oases55330982oases
oses46641512_oses
oyesses1037332oyesses
pases75346502pases
passes86030472passes
peases85229472peases
peises84125042peises
perses85428062perses
pisses84525082pisses
poses74642762poses
posses85128802posses
presses93523152presses
puses75532202puses
pusses84322842pusses
rases55447212rases
resees63827482resees
reshes94124362reshes
reuses66025522reuses
rises55244042rises
roses56445772roses
ruses56136582ruses
sasses64124392sasses
sees45361052_sees
seises64026712seises
semes75731582semes
senses63923942senses
sepses84515882sepses
seres55448892seres
sexes126126222sexes
shes75734352_shes
sises55233832sises
sisses64520602sisses
sues46247652_sues
susses64221052susses
tasses64826762tasses
teases65426272teases
tenses64722552tenses
testes65125822testes
tosses65225392tosses
tresses73719542tresses
tusses64921242tusses
uses44931112_uses
vases84626262vases
verses94223762verses
vessel937952vessel
vessels1035932vessels
vises84427772vises
wises85633192wises
wisses94619602wisses
wusses93314892wusses
yeses85119322yeses
yessed104511162yessed

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 Filter178691538000.0931921408.6
2DLD Change Limit538001732.09325704.7
3Display Results1731730.0503460.0
 (SQL Overall)1786911732.23679915.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.