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

121 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
zygote1932548(None) 
zygose19455551zygose
zygotes20355161zygotes
bygone1256172bygone
zlote143912942z_lote
zygoid2045942zygoid
zygoma2143492zygoma
zygoses20436782zygoses
zygotene2142522zygotene
zygotic2254662zygotic
agate66525153_agate
agone65924553_agone
argot67728653argot_
argots74116033argots
augite7312613augite
azote144416343_azote
azygos1933333azygo_s
azygoses2163313azygoses
azygous2043123azygous
begone9512133begone
begot84625953begot_
bigot84828323bigot_
bigoted11258403bigoted
bigots95015133bigots
bygones1335913bygones
byte96521813by__te
capote10315733capote
cenote83715843cenote
cote66648733__cote
coyote11411783coyote
cygnet1237893cygnet
cymose13429653cymose
demote94817803demote
denote74118043denote
devote104513783devote
dote55442883__dote
dynode1135023dynode
emote75421193_emote
ergate7315143ergate
ergot65422893ergot_
ergots74512373ergots
fagot9323403fagot_
fagoted1236073fagoted
fagoter1135883fagoter
fagots1039963fagots
fytte1138583fy_tte
garote7717953garote
gate55746573__gate
gemote94613023gemote
gigot74023073gigot_
gigots83911953gigots
gite55438613__gite
gone55639043__gone
gore55744963__gore
got49870443__got_
goth86825083__goth
gyrate104912523gyrate
gyrose105310253gyrose
hyte109018943hy__te
ingate73018243ingate
ingot61221063ingot_
ingoted939183ingoted
ingots7912063ingots
jugate14379463jugate
keynote1443903keynote
kyte117017763ky__te
legate72917453legate
ligate72519253ligate
lyrate94112103lyrate
lysate9388103lysate
magot8326393magot_
magots9312363magots
mote67048083__mote
myope124010973my_ope
myosote1245853myosote
negate72915573negate
note46239963__note
orgone71110913orgone
peyote1139853peyote
pyrite11913313pyrite
pyrone112714473pyrone
pyrope132810533pyrope
quote143714773_quote
remote84222603remote
revote94917453revote
rote46249023__rote
rugate75813813rugate
rugose737283rugose
ryot75528563ry_ot_
ryots85313783ry_ots
sapote8314363sapote
shote85526103_shote
smote75820283_smote
togate74515683togate
tote46643673__tote
ungot61718063ungot_
vegete1039483vegete
vote74728623__vote
wrote84717483_wrote
wyte106018643wy__te
xylose1636763xylose
yente86220043_yente
yogee9518063_yogee
yoke115626393_y_oke
yore76335943_y_ore
yowe106728743_y_owe
zeroth1837963zeroth
zloty17399793z_loty
zonate154114923zonate
zone135231083z__one
zooty175415353z_ooty
zygomas2243413zygomas
zygomata2342843zygomata
zygosis20405953zygosis
zygosity2442983zygosity
zygotenes2242863zygotenes
zymase201997483zymase
zyme1819114943zy__me
zymogen2243693zymogen
zymoses21608693zymoses
zymotic2345713zymotic

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.393454684.5
2DLD Change Limit1127161214.68624053.8
3Display Results1211210.0304033.3
 (SQL Overall)1786911215.10934975.7
 
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.