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

109 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
zygotes2035516(None) 
zygoses20436781zygoses
zygote19325481zygote_
azygoses2163312azygoses
bygones1335912bygones
zygomas2243412zygomas
zygose19455552zygose_
zygosis20405952zygosis
zygotene2142522zygotene
zygotenes2242862zygotenes
zygotic2254652zygotic
zymoses21608692zymoses
agates76121333_agates
agones75719863_agones
argots74116023argot_s
augites8312183augites
azotes154312223_azotes
azygos1933323azygo__s
azygous2043113azygo_us
bigoses1039073bigoses
bigoted11258403bigoted
bigots95015133bigot_s
bygone1256173bygone_
bytes105217493by__tes
capotes11314643capotes
cenotes92814543cenotes
cotes76347843__cotes
coyotes12410703coyotes
cygnets1333813cygnets
dagoes85714603dago_es
demotes104717673demotes
denotes83817003denotes
devotes113713753devotes
dotes65836693__dotes
dynodes1235453dynodes
emotes84620283_emotes
ergates8314473ergates
ergots74512373ergot_s
fagoted1236073fagoted
fagoter1135883fagoter
fagoters1234853fagoters
fagots1039963fagot_s
fyttes1236933fy_ttes
garotes8614563garotes
gates65939503__gates
gemotes103712143gemotes
gigots83911953gigot_s
gites65630183__gites
goes55644093__go_es
gores65740373__gores
goths96513003__goths
goxes135018263__goxes
gyrates113610263gyrates
ingates82716893ingates
ingoted939173ingoted
ingots7912063ingot_s
keynotes1543633keynotes
kytes125012913ky__tes
legates82917673legates
ligates82318373ligates
litotes7311183litotes
lysates10317473lysates
magots9312363magot_s
motes75944003__motes
mycoses1437723mycoses
myopes13419963my_opes
myoses114013843my_oses
myosotes1344653myosotes
negates83215833negates
notes55034583__notes
orgones81010793orgones
peyotes1238483peyotes
pygmies15205673pygmies
pyoses114314303py_oses
pyrites12812203pyrites
pyrones123113303pyrones
pyropes142210193pyropes
quotes153312463_quotes
remotes94521613remotes
revotes104716393revotes
rotes56143903__rotes
ryots85313783ry_ot_s
sapotes9313933sapotes
shotes95321893_shotes
syboes1139343sybo_es
sycoses1249133sycoses
totes55139683__totes
votes84627083__votes
wytes114113433wy__tes
xyloses1746843xyloses
yentes95517603_yentes
yogees10510633_yogees
yokes125223023_y_okes
yores85031323_y_ores
yowes114926373_y_owes
zeroes154314343zero_es
zlote143912943z_lote_
zloties1639913z_loties
zlotys18374173z_lotys
zones145528043z__ones
zygoid2045933zygo_id
zygoma2143493zygo_ma
zygosities2343133zygosities
zymases21938333zymases
zymes1924712943zy__mes
zymogen2243693zymogen
zymogens2343673zymogens
zymosis21487493zymosis
zymotic2345703zymotic

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.1731032896.0
2DLD Change Limit1340271096.87619492.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.09525185.5
 
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.