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

147 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
zygoses2043678(None) 
azygoses2163311azygoses
zygose19455551zygose_
zygosis20405951zygosis
zygotes20355161zygotes
zymoses21608691zymoses
bigoses1039072bigoses
bygones1335912bygones
mycoses1437732mycoses
myoses114013842my_oses
pyoses114314302py_oses
sycoses1249132sycoses
xyloses1746842xyloses
zygomas2243412zygomas
zygote19325482zygote_
zymases21938332zymases
zymosis21487492zymosis
abioses9311493abioses
aegises8311373aegises
agones75719863_agones
aldoses8311203aldoses
amyloses1347223amyloses
apposes11511473apposes
argosies939523argosies
arguses84711743arguses
arkoses113910833arkoses
avgases11106313avgases
azygos1933333azygo__s
azygous2043123azygo_us
broses86524403_broses
bygone1256173bygone_
chaoses124715123chaoses
chooses125717423chooses
choses115825133_choses
closes85425593_closes
coses76949493__coses
cyanoses1337423cyanoses
cycases1437533cycases
cycloses1538183cycloses
cyeses11510123cy_eses
cymose13429653cymose_
dagoes85714603dago_es
degases93413103degases
demoses103815823demoses
deposes103117213deposes
doses65938503__doses
dynodes1235453dynodes
egises7312493_egises
eposes84418783_eposes
eroses65327053_eroses
ethoses10311763ethoses
exposes1639963exposes
eyases94513683ey_ases
eyasses10388023eyasses
fucoses12148303fucoses
gases65633993__gases
gnoses76515163_gnoses
goes55644093__go_es
gooses75723053_gooses
gores65740373__gores
gorses74723293__gorses
goxes135018263__goxes
gyrases11368313gyrases
gyrose105310253gyrose_
hexoses17228883hexoses
hognoses12108133hognoses
hoses85443173__hoses
hypnoses1646633hypnoses
imposes113213683imposes
ketoses114912873ketoses
kyboshes2042743kyboshes
kyphoses2045283kyphoses
ligases82310713ligases
looses67328243_looses
loses56742013__loses
lotoses73713643lotoses
lyases95211873ly_ases
lyses84518253ly__ses
meioses9310833meioses
mioses84318853_mioses
mitoses9312183mitoses
myases113711553my_ases
mycosis1437763mycosis
myiases1235493myiases
myopes13419963my_opes
myosis114012563my_osis
mysosts1234543mysosts
neguses837933neguses
nooses65623643_nooses
noses55435643__noses
opposes1149243opposes
orgones81010793orgones
oses46641513___oses
osmoses9138123osmoses
ostoses71213553ostoses
oyesses1037333oyesses
poses74642763__poses
proses84733473_proses
ptoses83514673_ptoses
pycnoses1554973pycnoses
pygmies15205673pygmies
pyknoses1783573pyknoses
pyosis114012123py_osis
pyrones123113303pyrones
pyropes142210193pyropes
pyrosis12411653pyrosis
reposes94021263reposes
riboses9310443riboses
rooses65526233_rooses
roses56445773__roses
rugosas844973rugosas
rugose737283rugose_
saroses73619333saroses
soroses73117483soroses
syboes1139343sybo_es
sycosis1238823sycosis
syngases1245073syngases
synopses1346223synopses
trioses75015653trioses
vamoses1239143vamoses
viroses10310533viroses
xeroses143612823xeroses
xylose1636763xylose_
yeses85119323_y_eses
yesses93615813_yesses
yogees10510633_yogees
yokes125223023_y_okes
yores85031323_y_ores
yowes114926373_y_owes
zeroes154314343zero_es
zones145528043z__ones
zoonoses1746203zoonoses
zygoid2045943zygo_id
zygoma2143493zygo_ma
zygosities2343133zygosities
zygosity2442983zygosity
zygospores2562283zygospores
zygotene2142523zygotene
zygotenes2242863zygotenes
zygotic2254663zygotic
zymase201997483zymase_
zymes1924712943zy__mes
zymogen2243693zymogen
zymogens2343673zymogens
zymolyses2643133zymolyses
zymosan2143803zymosan
zymosans2243223zymosans

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271476.14021828.5
3Display Results1471470.0632333.3
 (SQL Overall)1786911476.60927037.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.