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

267 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
asepses94636(None) 
asepsis985901asepsis
sepses84515881_sepses
apses76823912a__pses
asceses938622asceses
askeses1136462askeses
asperses104111672asperses
aspises9611642aspises
asses55629282as__ses
assesses737382assesses
avenses1049642avenses
caseases10410472caseases
caseoses1039292caseoses
seises64026712_seises
senses63923942_senses
sepsis83011292_sepsis
tsetses785452tsetses
abases85720773a_bases
abbesses1235333abbesses
abeles84719393abe_les
abioses9311493abioses
abscesses1344103abscesses
abscises1246233abscises
absences1247673absences
abuses85119103a_buses
abysses1234863abysses
accesses1287493accesses
accuses114112193accuses
adenoses947903adenoses
adepter1036113adepter
adeptest1145453adeptest
adepts9117103adep_ts
adiposes1137173adiposes
advises11138973advises
aedes64625153a_e_des
aegises8311373aegises
aeries64737783a_eries
agapes95212413agap_es
ageisms1056603ageisms
ageists848493ageists
ageless8310343ageless
agenes74720253age_nes
ageneses939303ageneses
akees96119243ake__es
akenes104817343ake_nes
aldoses8311203aldoses
alephs1136533alep_hs
aliases7914493aliases
amasses93912853amasses
amerces1149853amerces
amperes11313983amperes
amuses85117943a_muses
aneles64626293ane_les
anemoses10159433anemoses
anises64826693a_nises
ankuses1148203ankuses
anlases72514903anlases
antisepses1245073antisepses
anuses66218773a_nuses
aperies9423203aperies
apes66047433a__p_es
apexes1539133ape_xes
apheses12610703apheses
apoapses1244723apoapses
appeases1238663appeases
apples104315763a_pples
apposes11511473apposes
apres75426403a__pres
apse67725383a__pse_
apsis75718293a__psis
arcuses94814693arcuses
arenes64928393are_nes
areoles71016953areoles
arepas85515703arep_as
aretes64425353are_tes
arguses84711743arguses
arises65233803a_rises
arkoses113910833arkoses
arouses74921293arouses
arrases71214543arrases
arrises71617583arrises
arses55733873a__rses
ascesis938373ascesis
ascites9312603ascites
aseptic1137373aseptic
ashes86230613as__hes
ashless10318453ashless
asides75118873as_ides
askesis1136123askesis
aspects1146743aspects
aspen75216093as_p_en
aspens85013353as_pens
asper75520433as_p_er
asperges11318093asperges
aspers86220313as_pers
asperse94210663asperse_
aspersed11428293aspersed
asperser10408303asperser
aspersers11377243aspersers
aspics104211563as_pics
aspires9612043aspires
aspis74618143as_p_is
asps65622093as_p__s
assess65710463as__sess
assessed945023assessed
asset55932263as__set
assets65617663as__sets
assists738473assists
assizes1638453assizes
assumes967163assumes
assures7611403assures
asynapses1442023asynapses
atlases72410643atlases
atopies92816433atopies
auxeses1435623auxeses
avenges1157543avenges
avenues1057183avenues
averse95811183averse_
avgases11106313avgases
avulses1035433avulses
aweless1038723aweless
axises134413993a_xises
baseless1099563baseless
baseness10910943baseness
basses85428303bas__ses
beses75830723_be_ses
bicepses1443873bicepses
blesses93812393blesses
caresses10314063caresses
casease939323casease_
caseates10313713caseates
casefies1339213casefies
caseose939163caseose_
casernes103810753casernes
casettes1039653casettes
cassises103811743cassises
ceases84427073_ceases
censes83721803_censes
cepes94424463_cep_es
cesses84221363_cesses
cheeses123613103cheeses
chesses124112633chesses
clepes104214623clep_es
copses104922483_copses
corpses113913813corpses
creases94020963creases
creeses93914623creeses
crepes105419343crep_es
cresses94219813cresses
cyeses11510123cye_ses
danseuses1044133danseuses
deposes103117213_deposes
despises1139433despises
dieses75218693die_ses
diseases92415813diseases
diseuses93112763diseuses
dresses83716173dresses
eases56041613__eases
elapses957663elapses
emeses86114963eme_ses
epees75219833__epees
eposes84418783__eposes
erses55826803__erses
eses45336103__e_ses
espies83716803es_pies
esses56422973__esses
feases95422923_feases
fesses94820253_fesses
flenses1039473flenses
gasses75724783gas__ses
greases84816713greases
guesses8169373guesses
ileuses738673ileuses
jesses135215953_jesses
lapses85217693_lapses
lasses64827593las__ses
leases65428113_leases
lenses64620893_lenses
leses54930813_le_ses
loesses7310033loesses
masses85028713mas__ses
masseuses1144793masseuses
menses84222453_menses
messes84924343_messes
miseases102614343miseases
nesses64718323_nesses
obsesses1036223obsesses
osmoses9138133osmoses
osteoses839033osteoses
ostoses71213553ostoses
oyesses1037333oyesses
pareses94718883pare_ses
passes86030473pas__ses
passuses1036773passuses
pastises103616053pastises
peases85229473_peases
peises84125043_peises
perses85428063_perses
pleases94515483pleases
presses93523153presses
reposes94021263_reposes
reuses66025523_reuses
samples112815453samples
saroses73619333saroses
sasses64124393_sasses
sedges83817813_sedges
sees45361053_se__es
segues7412073_segues
seines65029903_seines
seise54727853_seise_
seised74218123_seised
seiser65318343_seiser
seisers73816393_seisers
seisms84912143_seisms
seizes154317533_seizes
selles64426983_selles
selves94119613_selves
semes75731583_se_mes
semises93916553_semises
sense55526823_sense_
sensed73918163_sensed
sensei64712593_sensei
senseis73310643_senseis
sepals85217383_sepals
sepias83616103_sepias
sepoys1138473_sepoys
septet8921133_septet
septets998953_septets
septs75420603_sep_ts
seres55448893_se_res
serges74225973_serges
series64540973_series
serves94423653_serves
sexes126126223_se_xes
sipes76036953_sip_es
sises55233833_s_ises
sisses64520603_sisses
skepsis1344253skepsis
souses64229243_souses
spaes76029973_s_paes
speises93813933speises
spenses92913573spenses
spies76037623_s_pies
spues75025383_s_pues
stases64225563_stases
steppes113110693steppes
sudses74114503_sudses
supes75628303_sup_es
susses64221053_susses
tasses64826763tas__ses
teases65426273_teases
teepees939263teepees
tenses64722553_tenses
tepees84215243_tepees
theses96517973the_ses
tmeses85712243tme_ses
tresses73719543tresses
tsetse664693tsetse_
uneases73316263uneases
ureases74416723ureases
useless7188423useless
veepees1245813veepees
verses94223763_verses
weepies122811743weepies
woopses1237883woopses
yeses85119323_ye_ses
yesses93615813_yesses

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272676.92319359.7
3Display Results2672670.0932871.0
 (SQL Overall)1786912677.41924085.6
 
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.