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__
fuzzy1929814514fuzzy__
gyoza1836114gyoz__a
huzza1646094huzz__a
jazzy23396364jazzy__
lezzy16608084lezzy__
muzzy188410604muzzy__
pizza1538184pizz__a
sylva11268444sy__lva
syzygal2341184sy_zygal
syzygy2141114sy_zygy
tazza1338084tazz__a
tizzy16548894tizzy__
zanza1378704zanz__a
zelkova2341584zelkova
zemstva2141584zemstva
zizzle13247314zizz_le
zizzled15315854zizzled
zizzles14307094zizzles
zygoma2143494zy_goma
zzz1017911914z_zz___
abaya104413175_abay_a
adyta936855__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
boozy194917065boozy__
boyla102912365__boyla
brava106414795__brava
braza165214255braz__a
bunya103810095_buny_a
buzukia2242225buzukia
buzz146617805buzz___
buzzard1844275buzzard
buzzcut1942475buzzcut
buzzed17408475buzz_ed
buzzer16379115buzz_er
buzzers17347175buzzers
buzzes165011175buzz_es
buzzing18186545buzzing
buzzwig2141995buzzwig
byway1647535byway__
byways1734675byway_s
byzant2096815by_zant
byzants2153225byzants
canzona1836075canzona
casava1157875_casava
cassava1255005cassava
colza165112985colz__a
coryza2074585_coryza
cozey196718545cozey__
cozeys204610915cozey_s
cozy185823805_cozy__
cozzes164510895cozz_es
crazy195511225crazy__
cyma116715845___cyma
cymatia1446445cymatia
cypsela1442445cypsela
dazzle1536855dazz_le
dazzled1735035dazzled
dazzler1634715dazzler
dazzles1636415dazzles
deva85720985___deva
diptyca1542745diptyca
ditzy186513285ditzy__
diva85920885___diva
dizzied17236135dizzied
dizzier16317545dizzier
dizzies16279755dizzies
dizzily1934845dizzily
dizzying2133025dizzying
doozy186813715doozy__
dozy175920325_dozy__
dykey16608675dykey__
dyspnea1352815dyspnea
dysuria1144925dysuria
ecthyma1752615ecthyma
eczema1973075_eczema
enzym1964395_enzy_m
enzyme2054345_enzyme
enzyms2063435_enzyms
epizoa1745015epiz_oa
etyma1036585__etyma
eyra76217555___eyra
eyry106315885ey_ry__
fava106820265___fava
fazenda2043255fazenda
fezzed18398245fezz_ed
fezzes174910405fezz_es
fizz157519825fizz___
fizzed18369445fizz_ed
fizzer17369385fizz_er
fizzers18357005fizzers
fizzes174512555fizz_es
fizzier18326715fizzier
fizzing19276405fizzing
fizzle17369715fizz_le
fizzled19357275fizzled
fizzles18339065fizzles
fozy197017165_fozy__
frizzy20555835frizzy__
furzy2010116065furzy__
fuzz158420575fuzz___
fuzzed18479255fuzz_ed
fuzzes175412255fuzz_es
fuzzier18256525fuzzier
fuzzily2145075fuzzily
fuzzing19336185fuzzing
gauzy18489215gauzy__
gazania1746125gazania
geneva1085855_geneva
gingiva1253295gingiva
gizzard17114205gizzard
glazy187410985glazy__
guava938585__guava
guzzle15297915guzz_le
guzzled17326265guzzled
guzzler16286565guzzler
guzzles16328045guzzles
gynecia1384235gynecia
gyozas1933615gyoz_as
gypsy14636995gypsy__
gyttja1741575gy_ttja
gyve116215085___gyve
halva115414435__halva
hamza19139775hamz__a
hazy1918119195_hazy__
hazzan17236805hazz_an
hazzans18215785hazzans
helluva1353535helluva
hoya107418375__hoy_a
hryvna1541575__hryvna
hutzpa2052815hutz_pa
huzzaed1943105huzzaed
huzzah2044425huzz_ah
huzzahs2143085huzzahs
huzzas1735865huzz_as
hyaena1235365hy_aena
hydra12249225hy__dra
hydria13227905hy_dria
hyena11810255hy__ena
hyla106716515___hyla
hymenia1546395hymenia
hypha1637385hy__pha
hypogea1645475hypogea
hyponea1546455hyponea
hypoxia2246375hypoxia
isozyme21103295isozyme
izzard15135245_izzard
java147316645___java
jazz193714465jazz___
jazzbo2342715jazz_bo
jazzbos2442035jazzbos
jazzed22416295jazz_ed
jazzer21376505jazz_er
jazzers22324765jazzers
jazzes21347885jazz_es
jazzier2233885jazzier
jazzily2533375jazzily
jazzing2333885jazzing
jazzman2442555jazzman
jazzmen2442505jazzmen
kabaya15387125kabay_a
kava115819705___kava
kiva116516405___kiva
kopiyka154835kopiyka
larva8312485__larva
lava76725425___lava
lazy166423075_lazy__
leva77020715___leva
lezzes14387835lezz_es
lezzie1435335lezz_ie
lezzies1536205lezzies
lycea10418945ly__cea
lycra10317975ly__cra
lysozyme2551755lysozyme
lyssa835715ly__ssa
lytta888065ly__tta
matza16311815matz__a
maya95824595__may_a
mazuma1935605_mazuma
mazurka2272875mazurka
mazy186419705_mazy__
mazzard1844465mazzard
mezuza1643535_mezuza
mezzo1537435mezz__o
mezzos1635055mezz_os
mirza16410445mirz__a
mitzvah2441785mitz_vah
mizuna1734305_mizuna
mizzen16447955mizz_en
mizzens17366125mizzens
mizzle16279995mizz_le
mizzled18327635mizzled
mizzles17329495mizzles
mizzly19256105mizz_ly
mozetta1894755mozetta
mozzetta1851935mozzetta
muzzier17326555muzzier
muzzily2045025muzzily
muzzle16319395muzz_le
muzzled18267755muzzled
muzzler17257945muzzler
muzzles17299685muzzles
myalgia13124295myalgia
mycelia1444845mycelia
myeloma1444045myeloma
myna95815305___myna
myoma1239275my__oma
myomata1445925myomata
myopia13318445my_opia
myopy15457355myopy__
myrica1336835my_rica
mythy16568675mythy__
myxoma2043945my_xoma
nova76518955___nova
nozzle14236635nozz_le
nozzles15276305nozzles
nuzzle14298085nuzz_le
nuzzled16276395nuzzled
nuzzler15296495nuzzler
nuzzles15298125nuzzles
nyala836825ny__ala
nympha1643575ny_mpha
oozy167018135_oozy__
ottava963685_ottava
ova66823795____ova
oyez166020355oyez___
oyezes1835055oyez_es
palmyra1444145palmyra
papaya1337505papay_a
pavlova1542115pavlova
phyla13469185__phyla
piasava1243885piasava
piazza1643825piaz_za
piraya1167715piray_a
pitaya1186605pitay_a
pizazzy1952245pizazzy__
pizzas1646985pizz_as
pizzaz1565445pizz_az
pizzazz0243025pizzazz
pizzeria1842435pizzeria
pizzle16279495pizz_le
pizzles17329275pizzles
playa105812945_play_a
plaza164311065plaz__a
pozzolan1892665pozzolan
precava1445095precava
propyla14296635propyla
pteryla1243305pteryla
puzzle16318605puzz_le
puzzled18286655puzzled
puzzler17276965puzzler
puzzles17318975puzzles
pya87023755___py_a
pyaemia1445735pyaemia
pyemia1337555py_emia
pygidia1444195pygidia
pygmy16334225pygmy__
pyjama20303485py_jama
pyrexia19225465pyrexia
pyrola1139005py_rola
pyuria1136955py_uria
pyxidia2043845pyxidia
raya75224825__ray_a
razz125219425razz___
razzed15478285razz_ed
razzes144910075razz_es
razzing1636325razzing
rhizoma2143285rhizoma
rhyta1135085__rhyta
ritzy175611165ritzy__
rozzer1437355rozz_er
rozzers1535635rozzers
rufiyaa1341195rufiyaa
rya67622015___ry_a
saliva93110745_saliva
scuzzy1933085scuzzy__
selva83014275__selva
shiva115915005__shiva
silva82714025__silva
sizy164816395_sizy__
sizzle14309615sizz_le
sizzled16367885sizzled
sizzler15266865sizzler
sizzles15349635sizzles
snazzy1734015snazzy__
soya75724435__soy_a
sozzled16265185sozzled
syconia1248315syconia
sylvae12236865sy__lvae
sylvan12257365sy__lvan
sylvas12288175sy__lvas
syncytia1643725syncytia
synovia1345535synovia
synura935985sy_nura
syringa11366355syringa
syzygial2451435syzygial
tazzas1436285tazz_as
tazze1339575tazz__e
thuya1135585_thuy_a
tizzies15287895tizzies
tryma1037225__tryma
tyiyn11635335ty_iy_n
tympana14255855tympana
typey135511885typey__
typy126013045ty_py__
ulva75412695___ulva
viva106119095___viva
vizsla1833705_vizsla
volva11399005__volva
vulva11448805__vulva
whizzy23274075whizzy__
wizzen17387205wizz_en
wizzens18385485wizzens
wizzes175110775wizz_es
woozy204410605woozy__
xylyl1842565xy_ly_l
xylyls1931835xy_lyls
ya510251505____y_a
yakuza2261875_yakuza
yantra9449625_yantra
yautia937255_yautia
yay96948715_y_ay__
yays105728915_y_ay_s
yea66445755____yea
yenta83917045_y_enta
yerba101010765_y_erba
yeshiva1642405yeshiva
yoga87418055_y__oga
yttria954805_yttria
yuca95716725_y__uca
yucca12467445_y_ucca
yuga85615425_y__uga
yurta86014255_y_urta
za1114939205___z__a
zamarra1843785zamarra
zamia165115215__zamia
zanana153810365z_anana
zany167316995z_any__
zanzas1487055zanz_as
zappy21548945zappy__
zareba1736425z_areba
zareeba1842425zareeba
zariba1736985z_ariba
zarzuela164755zarzuela
zayin174512045__zayin
zazen1337285z_az_en
zazens1435835z_azens
zebra1637885__zebra
zelkovas2441465zelkovas
zemstvo2141465zemstvo
zenaida17914785zenaida
zenana15297985z_enana
zephyr2342085zephy_r
zephyrs2441945zephyrs
zesty176512165zesty__
zeta135121645___zeta
zeugma1842715z_eugma
zigzag1642965zigz_ag
zigzags1742275zigzags
zincy195413515zincy__
zingara1745515zingara
zingy186516135zingy__
zinky215314815zinky__
zinnia1536015z_innia
zippy21518745zippy__
zizit13313275z_iz_it
zizith1744825z_izith
zizzling16233925zizzling
zloty17399795zloty__
zlotych2441415zlotych
zlotys18374175zloty_s
zoa128529995___z_oa
zoaria1548385z_oaria
zoea137118425___zoea
zoecia1735555z_oecia
zona136321965___zona
zonula1537225z_onula
zooecia1843845zooecia
zooey173914805zooey__
zooglea1733375zooglea
zooty175415355zooty__
zorilla1646025zorilla
zouave1833575z_ouave
zoysia1844165z_oysia
zuz1110622035z_uz___
zuzim1534875z_uz_im
zydeco2142495zy_deco
zydecos2241905zydecos
zygoid2045945zy_goid
zygomas2243415zygomas
zygomata2342845zygomata
zygose19455555zy_gose
zygoses20436785zygoses
zygosis20405955zygosis
zygote19325485zy_gote
zygotes20355165zygotes
zygotic2254665zygotic
zymase201997485zy_mase
zymases21938335zymases
zyme1819114945___zyme
zymes1924712945zy__mes
zymogen2243695zymogen
zymogram2554405zymogram
zymosan2143805zymosan
zymoses21608695zymoses
zymosis21487495zymosis
zymotic2345715zymotic
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.1701051123.5
2DLD Change Limit16272542615.28310647.5
3Display Results4264260.1403042.9
 (SQL Overall)17869142615.59311459.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.