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

346 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
lysate938810(None) 
lyrate94112101lyrate
lysates10317471lysates
ansate64517862ansate
gyrate104912522gyrate
lanate6421262lanate
late47560482l__ate
legate72917452legate
ligate72519242ligate
lobate82915242lobate
locate83919842locate
lunate6316042lunate
luxate1338082luxate
lyase85512412ly_ase
lyrated11388472lyrated
lyse76320592lys__e
lysine94210552lysine
lyttae994712lyttae
misate81222692misate
sate45556102__sate
abate76627843_abate
ablate82219213ablate
acuate8315633acuate
acylate12310533acylate
adnate72913483adnate
aerate64830553aerate
agate66525143_agate
agnate73314873agnate
alate55340323_alate
alkylate1554663alkylate
ansae55720973ansa_e
ansated84214003ansated
ate37059243___ate
aurate64426473aurate
aviate9315203aviate
baste74829983bas_te
bate66552423__bate
berate84729023berate
binate8419773binate
bistate9313813bistate
blate75933783_blate
borate85026153borate
bursate94111203bursate
byname13256363byname
bypath1645353bypath
byte96521813by__te
calycate1537893calycate
carate84734003carate
caseate9314783caseate
caste75932363cas_te
cate66254593__cate
cerate84829463cerate
chaste114617393chaste
clavate1238713clavate
climate11312833climate
clypeate1543873clypeate
clyster12317453clys_ter
comate104124843comate
costae85319683costae
costate94019273costate
crate76537403_crate
create85126373create
curate85226243curate
cuspate1138233cuspate
cyanate12259703cyanate
cymae126713013cyma_e
cyst96322813cys_t_
cysts105912773cys_ts
date56443323__date
debate94419193debate
delate73827753delate
derate74531233derate
dialysate1343323dialysate
dilate73220693dilate
disrate81418523disrate
donate73619503donate
dosage82810003dosage
elate55335883_elate
elevate101110373elevate
eluate62315433eluate
enate54428143_enate
equate152012463equate
ergate7315143ergate
ersatz1536653ersatz
estate64719763estate
fate75444283__fate
fissate103010033fissate
fixate1638733fixate
flyte115713943fly__te
folate93320393folate
fossate10388603fossate
fytte1138583fy_tte
gate55746573__gate
gelate73421253gelate
gestate83614073gestate
geste65920693ges_te
globate1057823globate
grate64932883_grate
gyrase10508773gyrase
gyrated12428413gyrated
gyrates113610263gyrates
hamate113319823hamate
hastate10313913hastate
haste85927863has_te
hate78450173__hate
humate113214443humate
hydrate14239813hydrate
hyte109018943hy__te
ideate7313683ideate
ingate73018233ingate
inmate82917353inmate
innate63917313innate
insane6314883insane
instate71616473instate
iodate7313503iodate
irate55627983_irate
jugate14379463jugate
karate105320923karate
kyat116025523ky_at_
kyats125012443ky_ats
kyte117017763ky__te
labiate91313573labiate
lace66848473l__ace
lactate9312693lactate
lade56345983l__ade
lake85741603l__ake
lame66849293l__ame
lanated8313203lanated
lane45153323l__ane
lasagne844063lasagne
lase46148513l__ase
lassie64917743lassie
last46260323las_t_
lasted74323603las_ted
laster64830633las_ter
lasts57731263las_ts
lat37593403l__at_
lated65240673l__ated
laten54328343l__aten
later54843923l__ater
latex124717113l__atex
lath76640383l__ath
lathe85626713l__athe
lati46438273l__ati
latke94817093l__atke
lats45962703l__ats
latte55426303l_atte
latu47934183l__atu
lavage1038263lavage
lave75642143l__ave
layette1037133layette
laze136235053l__aze
lease55230263l_ease
least56134883least_
leasts64616413leasts
leave84723723l_eave
legated92513983legated
legatee82814633legatee
legates82917673legates
legato72810953legato
lenite6719983lenite
lessee64116363lessee
lest46956323les_t_
liane54720663l_iane
librate93214233librate
ligase7259913ligase
ligated92414133ligated
ligates82318373ligates
limbate1139203limbate
linage7713403linage
lineate7815153lineate
lipase8239103lipase
liquate1638413liquate
lisente71210703lisente
lisle53916723lis_le
list47055343lis_t_
listed74322833lis_ted
listee64223063listee
listel64214733lis_tel
listen64816813lis_ten
lister64527253lis_ter
lists56628693lis_ts
lite47054543l__ite
loath84918603l_oath
loathe94211383l_oathe
lobated102610943lobated
locale83915653locale
located103114183located
locater93113603locater
locates93218813locates
losable91910953losable
lose45144583los__e
lost47951493los_t_
lotte54923853l_otte
lovage1037353lovage
lovat8321043lovat_
lovats939073lovats
lucite8313343lucite
lunated8310823lunated
lust47442603lus_t_
lusted74319443lus_ted
luster64023673lus_ter
lustrate8310443lustrate
lustre64011683lustre
lusts55022803lus_ts
lusty85417573lus_ty
lute46341013l__ute
luxated1535713luxated
luxates1436973luxates
lyard95113213ly_ard
lyart85121883ly_art
lyases95211873lyases
lycee104716743ly_cee
lychee143710893lychee
lyddite1243333lyddite
lye66533413ly___e
lyrately1443163lyrately
lyre75623793ly__re
lysed95011563lys_ed
lyses84518253lys_es
lysin84512783lys_in
lysines10369093lysines
lysing104710443lysing
lysins94610953lysins
lysis84511463lys_is
lysogen1144363lysogen
lyssa835713lys_sa
lyssas935443lyssas
lytta888063ly_tta
lyttas985073lyttas
malate84624553malate
mate65154213__mate
metate82720533metate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
moste75925083mos_te
mutate83017483mutate
myosote1245853myosote
negate72915573negate
nidate7313783nidate
notate63217863notate
nutate63017373nutate
oblate82214743oblate
oleate6318883oleate
opiate8513463opiate
orate55133303_orate
ornate6315133ornate
outate62923403outate
ovate84214393_ovate
oyster94111703oys_ter
palate84226783palate
paste74932953pas_te
pate65350463__pate
pedate93117763pedate
pesade9311103pesade
pirate82322883pirate
piste75824603pis_te
placate11312433placate
planate9314573planate
plate74635113_plate
playdate1465263playdate
playmate1566463playmate
plicate11314513plicate
plumate1149803plumate
prate75135983_prate
pulsate9510233pulsate
pupate104213123pupate
pyrite11913313pyrite
quate144521413_quate
ramate83921683ramate
rate45458763__rate
rebate84424103rebate
redate74124683redate
relate64033633relate
remate84428683remate
resale64025543resale
resat55139683resat_
resite64128453resite
reslate73520593reslate
restate73824873restate
roseate7613453roseate
rotate63320343rotate
rugate75813813rugate
sabe66140573__sabe
sade55544473__sade
sae38365183__sa_e
safe75930953__safe
sage55044593__sage
sake85244963__sake
sale44959703__sale
same65245643__same
sane45954333__sane
sat36288483__sat_
sated66238533__sated
satem76021453__satem
sates54949323__sates
sati45539323__sati
saute55028083__saute
savate9313783savate
save75741363__save
sedate73019803sedate
senate63725143senate
sensate7311883sensate
sesame8311013sesame
site47052413__site
skate94721543_skate
slate55438283_slate
solate64526073solate
spate74731583_spate
state56237333_state
stylate10179773stylate
system1135733sys_tem
taste55127233tas_te
tate44748603__tate
testae64216253testae
testate73916233testate
tisane6311573tisane
togate74515683togate
tryste9399583trys_te
tsade64311123_tsade
tubate82813173tubate
ululate749963ululate
unsafe9310693unsafe
unsated83419933unsated
unstate71916213unstate
update93810293update
uprate83916543uprate
upstate91610493upstate
urate55432163_urate
ursae55214453ursa_e
usage6410213_usage
vacate11314553vacate
velate93720143velate
visage1049083visage
waste86125053was_te
wyte106018643wy__te
xyst144714073xys_t_
xyster16366803xys_ter
xysti15538153xys_ti
xysts15558123xys_ts
yare75636943_y_are
yente86220043_yente
zonate154114923zonate
zygote19325483zygote
zymase201997483zymase

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.1431249587.4
2DLD Change Limit1127163465.31021227.1
3Display Results3463460.1103145.5
 (SQL Overall)1786913465.56332121.3
 
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.