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

327 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
sycoses124913(None) 
mycoses1437721mycoses
sycosis1238801sycosis
coses76949492__coses
cycases1437532cycases
cycloses1538182cycloses
fucoses12148302fucoses
mycosis1437752mycosis
myoses114013842my_oses
psychoses1946682psychoses
pycnoses1554972pycnoses
pyoses114314302py_oses
saroses73619332saroses
scones84521302s_cones
scopes104719592s_copes
scores84725922s_cores
scouses93313242s_couses
soroses73117482soroses
sucroses1039932sucroses
syboes1139342sybo_es
sycees11409652syc_ees
syces106416462syc__es
syncopes1545762syncopes
synopses1346222synopses
xyloses1746842xyloses
zygoses20436782zygoses
zymoses21608692zymoses
abioses9311493abioses
accosts11107993accosts
accuses114112193accuses
alcoves1297873alcoves
aldoses8311203aldoses
amyloses1347213amyloses
ancones93116343ancones
apposes11511473apposes
arcuses94814693arcuses
arkoses113910833arkoses
asceses938623asceses
azygoses2163313azygoses
becomes132911963becomes
bigoses1039073bigoses
broses86524403_broses
bygones1335913bygones
cases75048383__cases
chaoses124715113chaoses
chooses125717413chooses
choses115825123_choses
closes85425593_closes
codes86247293__codes
cokes115537193__cokes
coles76055063__coles
comes97246993__comes
cones76457423__cones
copes97747103__copes
copses104922473__copses
cores76361853__cores
corses84433463__corses
cosec96320183__cosec
cosecs105015213__cosecs
coset75748843__coset
cosets85824403__cosets
cosey106226713__cosey
coseys115215813__coseys
coshes115022783__coshes
cosies84932153__cosies
coss66143493__cos_s
costs77231143__costs
cotes76347843__cotes
coves105539173__coves
coxes145430863__coxes
cozes166033243__cozes
cyanoses1337423cyanoses
cyclases1537133cyclases
cycles1339303cyc_les
cyclones1537483cyclones
cyclopes1746263cyclopes
cyclosis1547473cyclosis
cyeses11510123cy_eses
cymose13429653cymose_
decodes113914983decodes
demoses103815823demoses
deposes103117213deposes
doses65938503__doses
dynodes1235453dynodes
encases93116053encases
encloses10911053encloses
encodes10310643encodes
encores9315213encores
eposes84418783_eposes
eroses65327053_eroses
ethoses10311753ethoses
excises1638933excises
excuses1638903excuses
exposes1639963exposes
eyases94513683ey_ases
eyasses10388023eyasses
ficoes114613463fico_es
ficuses12159203ficuses
focuses12159653focuses
fucose11167683fucose_
fucuses12158353fucuses
fyces139813643fyc__es
glucoses1145333glucoses
gnoses76515163_gnoses
gooses75723053_gooses
gyrases11368313gyrases
gyrose105310253gyrose_
hexoses17228883hexoses
hocuses121710423hocuses
hoses85443173__hoses
hypnoses1646633hypnoses
icones84616383_icones
imposes113213683imposes
incases93615973incases
incises93414893incises
incloses101610533incloses
incomes11712373incomes
incuses93514853incuses
jocose1537103jocose_
ketoses114912873ketoses
kyboshes2042743kyboshes
kyphoses2045283kyphoses
lactoses1039813lactoses
locoes85516583loco_es
looses67328243_looses
loses56742013__loses
lotoses73713643lotoses
lyases95211873ly_ases
lycees11428863lyc_ees
lychees15516783lychees
lyches144213613lyc_hes
lyses84518253ly__ses
meioses9310833meioses
mioses84318853_mioses
mitoses9312183mitoses
mucosas11146673mucosas
mucose10149313mucose_
mucuses11148513mucuses
myases113711553my_ases
myceles1435213myceles
myiases1235493myiases
myopes13419963my_opes
myosis114012553my_osis
mysosts1234543mysosts
narcoses103910543narcoses
necroses10310563necroses
nooses65623643_nooses
noses55435643__noses
opposes1149243opposes
oses46641513___oses
osmoses9138123osmoses
osteoses839033osteoses
ostoses71213543ostoses
oyesses1037333oyesses
pocosen1146833pocosen
pocosens1255253pocosens
poses74642763__poses
proses84733473_proses
psiloses1036443psiloses
psyches1755803psyc_hes
psychosis1946783psychosis
ptoses83514673_ptoses
pycnosis1554733pycnosis
pyknoses1783573pyknoses
pyosis114012123py_osis
pyrones123113303pyrones
pyropes142210193pyropes
pyrosis12411653pyrosis
recodes102918633recodes
recuses94619463recuses
reposes94021263reposes
riboses9310443riboses
rooses65526233_rooses
roses56445773__roses
sacques18106863sacques
samosas939293samosas
sapotes9313933sapotes
sarodes84216143sarodes
sasses64124393s_asses
scales84529313s_cales
scapes105122263s_capes
scares85033003s_cares
scenes84520353s_cenes
scoffs14347503s_coffs
scolds95011233s_colds
scolex1538243s_colex
sconces113811453s_conces
scone74621833s_cone_
scoops105414363s_coops
scoots85315933s_coots
scope94821483s_cope_
scoped115116653s_coped
scops95820193s_co_ps
score75526733s_core_
scored94621133s_cored
scorer84818253s_corer
scorers94115313s_corers
scorns85713013s_corns
scoter83815473s_coter
scoters93313793s_coters
scots74025903s_co_ts
scours84913583s_cours
scouse84113633s_couse_
scouts84817943s_couts
scowed124413823s_cowed
scowls11549593s_cowls
scows106617803s_co_ws
screes85023963s_crees
scries85226823s_cries
scutes85219193s_cutes
scythes15356523scythes
secaloses1146913secaloses
secedes103711983secedes
secondes1138133secondes
seconds1038283seconds
secures9613163secures
seises64026713s_eises
semioses10611013semioses
semises93916553semises
senores73218113senores
senses63923943s_enses
sepses84515883s_epses
serosas7312663serosas
setose65114773setose_
shikses14116573shikses
shmoes114612093shmo_es
shoes85429653s_ho_es
shores94830403s_hores
shotes95321893s_hotes
shoves124919413s_hoves
sices75637273sic__es
sickees134514213sickees
sickies133717503sickies
sickles133417543sickles
silicoses1186173silicoses
sinuses73011593sinuses
sises55233833s__ises
sisses64520603s_isses
situses72710493situses
skoshes14246243s_koshes
skyboxes2442673skyboxes
sloes54728873s_lo_es
slopes84820453s_lopes
sloshes103811803s_loshes
smokes124814343s_mokes
smooshes13206863smooshes
snoozes16289763snoozes
snores64324313s_nores
socages101012053socages
socles8418453soc_les
sokes95031423s__okes
soles55547923s__oles
sones55444143s__ones
sorboses1038523sorboses
sores55454283s__ores
sorosis72611963sorosis
souses64229243s_ouses
speises93813933speises
spenses92913573spenses
splores91910943splores
sploshes1336133sploshes
spodes94817433s_podes
spokes124417213s_pokes
spores84726613s_pores
spouses92912813spouses
stases64225563s_tases
stenoses8310443stenoses
stokes104821793s_tokes
stoles63927673s_toles
stones65130033s_tones
stooges83611483stooges
stopes84525893s_topes
stores65533643s_tores
stoss54316343s_tos_s
stoves93818923s_toves
strobes93813263strobes
strokes114316323strokes
stylises11188943stylises
styluses11204773styluses
subcodes1338133subcodes
success1146403success
suckles134516743suckles
sucrases10310253sucrases
sucres84218893suc_res
sucrose939303sucrose_
sudses74114503s_udses
supposes1238203supposes
susses64221053s_usses
swisses10417143swisses
swooshes14185123swooshes
sycamores1642873sycamores
syce95820283syc__e_
sycee105018623syc__ee
sycomores1644323sycomores
syconia1248293syconia
sykes124816863sy__kes
symbioses1683553symbioses
synapses1344713synapses
syncoms1435943synco_ms
syncope1445383syncope_
syndeses1245263syndeses
synesis1039153synesis
syngases1245073syngases
synods1077953syno_ds
synopsis1346643synopsis
sysops1136013syso_ps
systoles1146473systoles
trioses75015653trioses
tycoons1235173tycoons
uncases93516553uncases
uncloses10910943uncloses
vamoses1239143vamoses
viroses10310533viroses
viscoses1338343viscoses
wyches17387913wyc_hes
xeroses143612823xeroses
xylose1636763xylose_
yeses85119323_y_eses
yesses93615813_yesses
yokes125223023_y_okes
yores85031323_y_ores
yowes114926373_y_owes
zygose19455553zygose_
zygosis20405953zygosis
zygotes20355163zygotes
zymases21938333zymases
zymosis21487493zymosis

Search took 9 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.1561145455.1
2DLD Change Limit1340273278.34316064.6
3Display Results3273270.2361385.6
 (SQL Overall)1786913278.73520456.9
 
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.