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

318 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
lycras1128724(None) 
lycra10317971lycra_
cycas126513822cyc_as
eyras84715922ey_ras
hydras13239312hydras
lauras63414332lauras
libras83711702libras
liras56021982l_iras
lucres84513302lucres
lycea10418942lycea_
lycees11428862lycees
lyches144213612lyches
lyres85019962ly_res
lyssas935442lyssas
lyttas985072lyttas
acres76327763_acres
agoras7613343agoras
arras55626133_arras
auras55932553_auras
barcas101016603barcas
boras75938303_boras
bras65746453__bras
buckras1537343buckras
buras74736293_buras
byres104421383by_res
byrls105711233by_rls
cacas95627983cac_as
cars67364763__cars
charas114223593charas
cobras104014193cobras
cocas95926573coc_as
cocoas104915743cocoas
copras103517153copras
crab85727673__crab
crabs95421393__crabs
crag75625303__crag
crags85622573__crags
cram85635493__cram
crams96229153__crams
crap85731843__crap
craps95328643__craps
crash109120013__crash
crass76328043__crass
craw97725263__craw
craws105723123__craws
cris66233433__cris
crus65828483__crus
cycad13507273cyc_ad
cycads14476213cycads
cyclase1436613cyclase
cycles1339303cycles
cyclos1338073cyclos
cymars13599143cymars
cymas126417883cy_mas
cypres1338523cypres
cyprus1335363cyprus
dachas124113253dachas
dobras94811913dobras
douras75016723douras
duras65727723_duras
durras74713373durras
dyers96617133dyer_s
ecrus75113863_ecrus
elytra934893elytra_
eras45441503__eras
escars83913133escars
extras13310223extras
eyas76427433ey__as
eyers86521333eyer_s
eyra76217553ey_ra_
eyres84921773ey_res
facias113415803facias
floras94715693floras
flyers125712803flyer_s
flytrap1543253flytrap
flytraps1642963flytraps
fyces139813643fyc_es
glycan1234903glyc_an
glycans1344233glycans
glycins1335563glycins
glycols1344133glycols
glycyls1642063glycyls
gyozas1933603gyozas
gyral94412783gy_ral
gyrase10508773gy_rase
gyres94820323gy_res
gyros95616483gy_ros
gyrus95310803gy_rus
hijras1635773hijras
horas86333093_horas
hybris14247003hybris
hydra12249223hydra_
hydrae13258573hydrae
hydrase14287663hydrase
hydros13279363hydros
hyenas1288953hyenas
hylas114815903hy_las
hyrax1838033hy_rax
ixoras1337193ixoras
jagras1438463jagras
koras95927113_koras
kyars124813963kyar_s
labra75415463labra_
lacers85225253lacers
laces76141763lac_es
laches116528343laches
lacks116129203lac_ks
lacs66942483lac__s
lactam10310943lactam
lactams1136953lactams
lactase937953lactase
lacunas9138173lacunas
lahars94013163lahars
lairds74711613lairds
lairs55425873lair_s
lamas75532793l_amas
lamias85020613lamias
lampas106615953lampas
lards65331863l_ards
lares54852633l_ares
laris54737463l_aris
larks95227813l_arks
lars46956573l_ar_s
larvas9310233larvas
las37281473l___as
lascars979013lascars
latrias71913213latrias
laura54116203laura_
laurae64011663laurae
lavas85422223l_avas
layers93921183layer_s
lazars153812393lazars
learns65513743learns
lears55938733lear_s
leas45954183l__eas
leches115421313leches
leers54828983leer_s
lehrs86111133lehr_s
lehuas935943lehuas
lemmas10349163lemmas
lianas63713383lianas
liards75212613liards
liars54723163liar_s
libra74712423libra_
librae84310173librae
liches114724293liches
lichis115212593lichis
lichts113712383lichts
licks115325393lic_ks
lidars7310783lidars
liers55130403lier_s
limas75627633l_imas
limbas105313193limbas
limpas105513083limpas
lingas75116563lingas
lira46928683l_ira_
litas54923773l_itas
litres65220393litres
livres94311863livres
llamas888973llamas
loca65527683loc_a_
local74820273loc_al
locals83714503locals
lochan1139093lochan
lochans1248833lochans
lochs106715513loc_hs
lockram1544913lockram
lockrams1643923lockrams
locks115126923loc_ks
locoes85516583locoes
locos75822603loc_os
locums10478303locums
locus74819993loc_us
loofas9429833loofas
loral55927823l_oral
loran55925093l_oran
lorans65117603l_orans
lords64923503l_ords
lores55045403l_ores
loris55329153l_oris
lotas55926303l_otas
loumas84812333loumas
lours55125293lour_s
lucerns935753lucerns
luces75528433luc_es
lucks115723563luc_ks
lucre76415523lucr_e
luffas12337483luffas
lumas75622913l_umas
lunars65012813lunars
lunas55025013l_unas
lures56138533l_ures
lurks95218743l_urks
lyard95113213lyar_d
lyart85121883lyar_t
lyase85512413ly__ase
lyases95211873lyases
lycee104716743lyc_ee
lyceum1343953lyceum
lyceums1442403lyceums
lych126015763lyc__h
lychee143710893lychee
lychees15516783lychees
lychnis1544383lychnis
lyes75530833ly__es
lyings10488503lyings
lymphs1635053lymphs
lyncean1292923lyncean
lynches15378873lynches
lynxes1634323lynxes
lyrate94112103ly_rate
lyre75623793ly_r_e
lyric104512723ly_ric
lyrics11357943lyrics
lyrism1137473ly_rism
lyrist9312293ly_rist
lyses84518253ly_ses
lysins94610953lysins
lysis84511463ly_sis
lyssa835713lyssa_
lytta888063lytta_
lyttae994713lyttae
macros104017013macros
madras94316423madras
maras75443283_maras
mbiras1077143mbiras
meccas1239493meccas
micas96823053mic_as
micra96214973micra_
micros104115363micros
mochas13310653mochas
moras76438763_moras
mudras94212253mudras
muras75329563_muras
murras84916003murras
mycs115314293myc__s
mylars114310443mylars
mynas105815233my_nas
myomas1338293myomas
myrrhs1443593myrrhs
nachas114914193nachas
nacres85614453nacres
nairas6312773nairas
nyalas936903nyalas
ocas66729633_oc_as
okras94410973_okras
operas8312453operas
orcas75918623orc_as
oyers87620883oyer_s
pacas96029403pac_as
pachas135017143pachas
paras76143043_paras
picaras11311273picaras
picas94626523pic_as
pleuras937413pleuras
plyers114912983plyer_s
pyas96225703py__as
pyran10514473py_ran
pyrans11411063py_rans
pyres105523883py_res
pyros105718293py_ros
pyurias1236703pyurias
ras37575393___ras
ricrac1037013ricrac
ricracs1136363ricracs
ryas77224613ry__as
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
sacrals93311793sacrals
scars75433533_scars
scrag85916173_scrag
scrags95713803_scrags
scram910621613_scram
scrams105216623_scrams
scrap97120403_scrap
scraps106017243_scraps
sirras63814863sirras
socas74026183soc_as
soras55041013_soras
sucrase9310343sucrase
sucres84218893sucres
suras55336323_suras
surras65919533surras
sutras64818583sutras
sycees11409653sycees
syces106416463syc_es
sylvas12288173sylvas
syngas10368913syngas
terras63516953terras
tetras63017613tetras
tiaras6314533tiaras
toras55540373_toras
tyers86220053tyer_s
tyres84725233ty_res
tyros85118593ty_ros
ultras6310183ultras
umbras1038633umbras
varas86028193_varas
vicars11712263vicars
wiccas1336543wiccas
wyches17387913wyches
yards95324613_yards
yarns85621793_yarns
yclad11246383_yclad
years84527673_years
yeas78638423_y_eas
yerbas11119293_yerbas
yerks125416563_yerks
yirds96612513_yirds
yirrs8469193_yirrs
yogas96615603_yogas
yores85031323_yores
yucas106013913_yucas
yuccas13426553yuccas
yugas95012063_yugas
yurts87216533_yurts
zebras1737853zebras

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163186.48317386.4
3Display Results3183180.0933419.4
 (SQL Overall)1786913186.71626606.8
 
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.