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 “zyzzyva” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

426 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
zyzzyva23215444(None) 
zyzzyvas241874211zyzzyvas
dizzy177410854dizzy__
fezzy199811454fezzy__
fizzy199015084fizzy__
fuzzy1929814504fuzzy__
gyoza1836104gyoz__a
huzza1646094huzz__a
jazzy23396364jazzy__
lezzy16608084lezzy__
muzzy188410594muzzy__
pizza1538184pizz__a
sylva11268444sy__lva
syzygal2341184sy_zygal
syzygy2141114sy_zygy
tazza1338084tazz__a
tizzy16548884tizzy__
zanza1378704zanz__a
zelkova2341584zelkova
zemstva2141584zemstva
zizzle13247304zizz_le
zizzled15315844zizzled
zizzles14307084zizzles
zygoma2143484zy_goma
zzz1017911914z_zz___
abaya104413165_abay_a
adyta936845__adyta
ajiva1586805__ajiva
aliya83713485_aliy_a
amboyna1443685amboyna
asyla839335__asyla
ava610139325____ava
azalea1537005_azalea
baiza164813225baiz__a
baklava1643105baklava
baryta114310295_baryta
bazooka2242625bazooka
benzyl2034165benzy_l
benzyls2133675benzyls
bezzant1746895bezzant
biznaga1942345biznaga
bizzes163910845bizz_es
boozy194917055boozy__
boyla102912365__boyla
brava106414785__brava
braza165214245braz__a
bunya103810085_buny_a
buzukia2242225buzukia
buzz146617805buzz___
buzzard1844265buzzard
buzzcut1942475buzzcut
buzzed17408455buzz_ed
buzzer16379105buzz_er
buzzers17347165buzzers
buzzes165011165buzz_es
buzzing18186545buzzing
buzzwig2141995buzzwig
byway1647535byway__
byways1734675byway_s
byzant2096815by_zant
byzants2153215byzants
canzona1836055canzona
casava1157865_casava
cassava1254995cassava
colza165112975colz__a
coryza2074565_coryza
cozey196718535cozey__
cozeys204610915cozey_s
cozy185823805_cozy__
cozzes164510895cozz_es
crazy195511225crazy__
cyma116715845___cyma
cymatia1446435cymatia
cypsela1442445cypsela
dazzle1536835dazz_le
dazzled1735015dazzled
dazzler1634705dazzler
dazzles1636405dazzles
deva85720985___deva
diptyca1542745diptyca
ditzy186513275ditzy__
diva85920885___diva
dizzied17236105dizzied
dizzier16317535dizzier
dizzies16279745dizzies
dizzily1934825dizzily
dizzying2133025dizzying
doozy186813705doozy__
dozy175920325_dozy__
dykey16608675dykey__
dyspnea1352815dyspnea
dysuria1144915dysuria
ecthyma1752595ecthyma
eczema1973075_eczema
enzym1964395_enzy_m
enzyme2054335_enzyme
enzyms2063435_enzyms
epizoa1745015epiz_oa
etyma1036565__etyma
eyra76217555___eyra
eyry106315885ey_ry__
fava106820265___fava
fazenda2043245fazenda
fezzed18398235fezz_ed
fezzes174910395fezz_es
fizz157519825fizz___
fizzed18369425fizz_ed
fizzer17369385fizz_er
fizzers18356995fizzers
fizzes174512555fizz_es
fizzier18326715fizzier
fizzing19276405fizzing
fizzle17369705fizz_le
fizzled19357265fizzled
fizzles18339055fizzles
fozy197017165_fozy__
frizzy20555835frizzy__
furzy2010116065furzy__
fuzz158420575fuzz___
fuzzed18479245fuzz_ed
fuzzes175412245fuzz_es
fuzzier18256515fuzzier
fuzzily2145065fuzzily
fuzzing19336185fuzzing
gauzy18489215gauzy__
gazania1746095gazania
geneva1085855_geneva
gingiva1253275gingiva
gizzard17114205gizzard
glazy187410985glazy__
guava938585__guava
guzzle15297905guzz_le
guzzled17326245guzzled
guzzler16286545guzzler
guzzles16328035guzzles
gynecia1384205gynecia
gyozas1933605gyoz_as
gypsy14636995gypsy__
gyttja1741575gy_ttja
gyve116215075___gyve
halva115414435__halva
hamza19139775hamz__a
hazy1918119195_hazy__
hazzan17236805hazz_an
hazzans18215775hazzans
helluva1353535helluva
hoya107418375__hoy_a
hryvna1541575__hryvna
hutzpa2052805hutz_pa
huzzaed1943095huzzaed
huzzah2044425huzz_ah
huzzahs2143085huzzahs
huzzas1735865huzz_as
hyaena1235365hy_aena
hydra12249225hy__dra
hydria13227895hy_dria
hyena11810255hy__ena
hyla106716515___hyla
hymenia1546395hymenia
hypha1637385hy__pha
hypogea1645475hypogea
hyponea1546455hyponea
hypoxia2246365hypoxia
isozyme21103285isozyme
izzard15135245_izzard
java147316645___java
jazz193714465jazz___
jazzbo2342715jazz_bo
jazzbos2442035jazzbos
jazzed22416265jazz_ed
jazzer21376505jazz_er
jazzers22324755jazzers
jazzes21347875jazz_es
jazzier2233885jazzier
jazzily2533365jazzily
jazzing2333885jazzing
jazzman2442555jazzman
jazzmen2442495jazzmen
kabaya15387115kabay_a
kava115819705___kava
kiva116516405___kiva
kopiyka154835kopiyka
larva8312485__larva
lava76725425___lava
lazy166423075_lazy__
leva77020715___leva
lezzes14387835lezz_es
lezzie1435325lezz_ie
lezzies1536205lezzies
lycea10418945ly__cea
lycra10317965ly__cra
lysozyme2551745lysozyme
lyssa835715ly__ssa
lytta888065ly__tta
matza16311815matz__a
maya95824585__may_a
mazuma1935605_mazuma
mazurka2272875mazurka
mazy186419695_mazy__
mazzard1844465mazzard
mezuza1643535_mezuza
mezzo1537435mezz__o
mezzos1635045mezz_os
mirza16410435mirz__a
mitzvah2441765mitz_vah
mizuna1734305_mizuna
mizzen16447935mizz_en
mizzens17366115mizzens
mizzle16279985mizz_le
mizzled18327625mizzled
mizzles17329475mizzles
mizzly19256075mizz_ly
mozetta1894745mozetta
mozzetta1851925mozzetta
muzzier17326535muzzier
muzzily2045015muzzily
muzzle16319385muzz_le
muzzled18267735muzzled
muzzler17257925muzzler
muzzles17299675muzzles
myalgia13124275myalgia
mycelia1444815mycelia
myeloma1444035myeloma
myna95815295___myna
myoma1239265my__oma
myomata1445895myomata
myopia13318425my_opia
myopy15457355myopy__
myrica1336815my_rica
mythy16568675mythy__
myxoma2043935my_xoma
nova76518955___nova
nozzle14236625nozz_le
nozzles15276295nozzles
nuzzle14298075nuzz_le
nuzzled16276375nuzzled
nuzzler15296475nuzzler
nuzzles15298115nuzzles
nyala836825ny__ala
nympha1643575ny_mpha
oozy167018125_oozy__
ottava963685_ottava
ova66823795____ova
oyez166020355oyez___
oyezes1835055oyez_es
palmyra1444145palmyra
papaya1337505papay_a
pavlova1542115pavlova
phyla13469175__phyla
piasava1243885piasava
piazza1643825piaz_za
piraya1167715piray_a
pitaya1186605pitay_a
pizazzy1952245pizazzy__
pizzas1646985pizz_as
pizzaz1565445pizz_az
pizzazz0243025pizzazz
pizzeria1842415pizzeria
pizzle16279485pizz_le
pizzles17329265pizzles
playa105812935_play_a
plaza164311055plaz__a
pozzolan1892665pozzolan
precava1445095precava
propyla14296635propyla
pteryla1243305pteryla
puzzle16318595puzz_le
puzzled18286635puzzled
puzzler17276945puzzler
puzzles17318965puzzles
pya87023755___py_a
pyaemia1445735pyaemia
pyemia1337555py_emia
pygidia1444195pygidia
pygmy16334225pygmy__
pyjama20303485py_jama
pyrexia19225465pyrexia
pyrola1139005py_rola
pyuria1136945py_uria
pyxidia2043845pyxidia
raya75224815__ray_a
razz125219425razz___
razzed15478265razz_ed
razzes144910055razz_es
razzing1636315razzing
rhizoma2143265rhizoma
rhyta1135085__rhyta
ritzy175611155ritzy__
rozzer1437355rozz_er
rozzers1535635rozzers
rufiyaa1341195rufiyaa
rya67622015___ry_a
saliva93110745_saliva
scuzzy1933085scuzzy__
selva83014275__selva
shiva115914995__shiva
silva82714025__silva
sizy164816395_sizy__
sizzle14309605sizz_le
sizzled16367865sizzled
sizzler15266845sizzler
sizzles15349625sizzles
snazzy1734015snazzy__
soya75724435__soy_a
sozzled16265165sozzled
syconia1248265syconia
sylvae12236865sy__lvae
sylvan12257365sy__lvan
sylvas12288175sy__lvas
syncytia1643705syncytia
synovia1345505synovia
synura935985sy_nura
syringa11366355syringa
syzygial2451435syzygial
tazzas1436275tazz_as
tazze1339575tazz__e
thuya1135585_thuy_a
tizzies15287885tizzies
tryma1037215__tryma
tyiyn11635335ty_iy_n
tympana14255845tympana
typey135511885typey__
typy126013045ty_py__
ulva75412695___ulva
viva106119095___viva
vizsla1833705_vizsla
volva11399005__volva
vulva11448805__vulva
whizzy23274075whizzy__
wizzen17387195wizz_en
wizzens18385475wizzens
wizzes175110775wizz_es
woozy204410595woozy__
xylyl1842565xy_ly_l
xylyls1931835xy_lyls
ya510251505____y_a
yakuza2261875_yakuza
yantra9449615_yantra
yautia937245_yautia
yay96948715_y_ay__
yays105728915_y_ay_s
yea66445755____yea
yenta83917045_y_enta
yerba101010765_y_erba
yeshiva1642385yeshiva
yoga87418055_y__oga
yttria954795_yttria
yuca95716725_y__uca
yucca12467445_y_ucca
yuga85615425_y__uga
yurta86014255_y_urta
za1114939205___z__a
zamarra1843765zamarra
zamia165115195__zamia
zanana153810355z_anana
zany167316985z_any__
zanzas1487025zanz_as
zappy21548945zappy__
zareba1736425z_areba
zareeba1842425zareeba
zariba1736965z_ariba
zarzuela164755zarzuela
zayin174512035__zayin
zazen1337285z_az_en
zazens1435815z_azens
zebra1637885__zebra
zelkovas2441465zelkovas
zemstvo2141465zemstvo
zenaida17914785zenaida
zenana15297985z_enana
zephyr2342085zephy_r
zephyrs2441945zephyrs
zesty176512155zesty__
zeta135121645___zeta
zeugma1842715z_eugma
zigzag1642965zigz_ag
zigzags1742275zigzags
zincy195413515zincy__
zingara1745485zingara
zingy186516135zingy__
zinky215314815zinky__
zinnia1536015z_innia
zippy21518745zippy__
zizit13313265z_iz_it
zizith1744825z_izith
zizzling16233925zizzling
zloty17399795zloty__
zlotych2441415zlotych
zlotys18374175zloty_s
zoa128529995___z_oa
zoaria1548375z_oaria
zoea137118425___zoea
zoecia1735555z_oecia
zona136321965___zona
zonula1537215z_onula
zooecia1843845zooecia
zooey173914805zooey__
zooglea1733375zooglea
zooty175415355zooty__
zorilla1646015zorilla
zouave1833575z_ouave
zoysia1844165z_oysia
zuz1110622035z_uz___
zuzim1534845z_uz_im
zydeco2142485zy_deco
zydecos2241895zydecos
zygoid2045915zy_goid
zygomas2243415zygomas
zygomata2342825zygomata
zygose19455535zy_gose
zygoses20436775zygoses
zygosis20405945zygosis
zygote19325465zy_gote
zygotes20355145zygotes
zygotic2254645zygotic
zymase201997475zy_mase
zymases21938335zymases
zyme1819114945___zyme
zymes1924712945zy__mes
zymogen2243695zymogen
zymogram2554405zymogram
zymosan2143805zymosan
zymoses21608685zymoses
zymosis21487475zymosis
zymotic2345695zymotic
zymurgy2541015zymurgy

Search took 16 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 Filter1786911627250.1561145455.1
2DLD Change Limit16272542614.84310963.1
3Display Results4264260.1432979.0
 (SQL Overall)17869142615.14211801.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2023  |  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.