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

140 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
zygose1945555(None) 
zygoses20436781zygoses
zygote19325481zygote
azygos1933332azygos_
azygoses2163312azygoses
bygone1256172bygone
cymose13429652cymose
gyrose105310252gyrose
rugose737282rugose
xylose1636762xylose
zygoid2045942zygoid
zygoma2143492zygoma
zygosis20405952zygosis
zygotes20355162zygotes
zymase201997482zymase
zymoses21608692zymoses
agone65924553_agone
aldose7311093aldose
amylose1237193amylose
appose10411993appose
argosy1036423argosy
ariose64818723ariose
arkose104911343arkose
arose55832083_arose
azygous2043123azygous
begone9512133begone
bigos85020013bigos_
bigoses1039073bigoses
brose75227033_brose
bygones1335913bygones
choose115116143choose
chose105925403_chose
close76425223_close
comose105016843comose
dagoes85714603dagoes
dagos76419443dagos_
depose94215763depose
dose56442433__dose
dynode1135023dynode
egos55821653_egos_
erose55727273_erose
expose1549523expose
filose96112503filose
fucose11167683fucose
goes55644093__goes
gogos77516523gogos_
gone55639043__gone
goose65925903_goose
gore55744963__gore
gorse65926813__gorse
gos47155133__gos_
gosh86123423__gosh
gyrase10508773gyrase
gyros95616483gyros_
hexose16267843hexose
hognose11117243hognose
hose76547243__hose
hypos1312014743hypos_
impose103113053impose
jocose1537103jocose
ketose105711813ketose
kybosh1842713kybosh
lanose6313593lanose
ligase7259913ligase
logos67225333logos_
loose56627683_loose
lose45144583__lose
lyase85512413ly_ase
lyse76320593ly__se
moose76327193_moose
morose85116243morose
mucose10149313mucose
mycoses1437733mycoses
myope124010973my_ope
myoses114013843my_oses
mysost1138263mysost
nodose738883nodose
noose55624063_noose
nose46739363__nose
oppose1039193oppose
orgone71110913orgone
ose38147343___ose
osmose8108003osmose
otiose639403otiose
pilose84514243pilose
porose84818743porose
pose66441733__pose
prose75835123_prose
pyoses114314303py_oses
pyrone112714473pyrone
pyrope132810533pyrope
pyros105718293pyros_
ramose8314403ramose
repose84121413repose
rerose63320843rerose
ribose839893ribose
rimose8310593rimose
roose56127093_roose
rose46148903__rose
rugosa734563rugosa
sagos66123873sagos_
segos64919483segos_
setose65114773setose
syboes1139343syboes
sycoses1249133sycoses
those85218143_those
torose64317693torose
triose64715383triose
typhose1546693typhose
typos106015813typos_
tyros85118593tyros_
uprose82311483uprose
vadose1037963vadose
vamose1159283vamose
venose9310843venose
whose114914533_whose
xyloses1746843xyloses
yogee9518063_yogee
yoke115626393_y_oke
yore76335943_y_ore
youse85322233_youse
yowe106728743_y_owe
zags146826683zag_s_
zeroes154314343zeroes
zeros144918113zeros_
zigs145422793zig_s_
zlote143912943z_lote
zone135231083z__one
zoos135828803z_oos_
zygomas2243413zygomas
zygosity2442983zygosity
zygospore2462223zygospore
zygotene2142523zygotene
zygotic2254663zygotic
zymases21938333zymases
zyme1819114943zy__me
zymes1924712943zymes_
zymogen2243693zymogen
zymosan2143803zymosan
zymosis21487493zymosis

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161404.67324120.7
3Display Results1401400.0463043.5
 (SQL Overall)1786911405.09235092.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.