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

274 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
zyzzyvas24187421(None) 
zyzzyva232154441zyzzyva_
gyozas1933604gyoz__as
huzzas1735864huzz__as
pizzas1646984pizz__as
sylvas12288174sy__lvas
syzygal2341184sy_zygal
tazzas1436274tazz__as
zanzas1487024zanz__as
zelkovas2441464zelkovas
zizzles14307084zizz_les
zygomas2243414zy_gomas
abayas114011695_abay_as
ajivas1655135__ajivas
aliyas93911805_aliy_as
amboynas1543225amboynas
azaleas1636985_azaleas
azygos1933315__azygos
baizas173810825baiz__as
baklavas1742785baklavas
barytas12378285_barytas
bazookas2341895bazookas
benzyls2133675benzy_ls
bezzants1843635bezzants
biznagas2041975biznagas
bizzes163910845bizz__es
boylas113011725__boylas
bravas114913315__bravas
brazas175812425braz__as
bunyas11359425_buny_as
buzzards1943605buzzards
buzzcuts2041195buzzcuts
buzzers17347165buzz_ers
buzzes165011165buzz__es
buzzwigs2241095buzzwigs
byways1734675byway__s
byzants2153215by_zants
canvas113813325__canvas
canzonas1935335canzonas
casavas1237805_casavas
cassavas1344795cassavas
colzas174010495colz__as
coryzas2134775_coryzas
cozeys204610915cozey__s
cozzes164510895cozz__es
cycas126513825___cycas
cymas126417885___cymas
czardas1934665_czardas
dazzlers1733225dazzlers
dazzles1636405dazz_les
devas96218885___devas
diptycas1652855diptycas
divas95418585___divas
dizzies16279745dizz_ies
dizzy177410855dizzy___
dizzying2133025dizzying
dyspneas1462745dyspneas
dysurias1244455dysurias
eczemas2063145_eczemas
enzymes2164415_enzymes
enzyms2063435_enzy_ms
eyas76427435___ey_as
eyras84715925___eyras
favas115618595___favas
fazendas2143035fazendas
fezzes174910395fezz__es
fezzy199811455fezzy___
fizzers18356995fizz_ers
fizzes174512555fizz__es
fizzles18339055fizz_les
fizzy199015085fizzy___
fuzzes175412245fuzz__es
fuzzy1929814505fuzzy___
gazanias1845695gazanias
genevas1185245_genevas
gizzards18133265gizzards
guavas1037155__guavas
guzzlers17274855guzzlers
guzzles16328035guzz_les
gyoza1836105gyoz__a_
gyttjas1841005gy_ttjas
gyves125711545___gyves
halvas124714175__halvas
hamzas20119005hamz__as
hazzan17236805hazz__an
hazzans18215775hazz_ans
hoyas115016155__hoy_as
hryvnas1641495__hryvnas
hutzpas2142695hutz_pas
huzza1646095huzz__a_
huzzah2044425huzz__ah
huzzahs2143085huzz_ahs
hyaenas1334985hy_aenas
hydras13239315hy__dras
hyenas1288945hy__enas
hylas114815905___hylas
hyponeas1646375hyponeas
hypoxias2346125hypoxias
isozymes22103095isozymes
izzards16143965_izzards
javas155915425___javas
jazzbos2442035jazz_bos
jazzers22324755jazz_ers
jazzes21347875jazz__es
jazzman2442555jazz_man
jazzy23396365jazzy___
kabayas16316805kabay_as
kavas125919955___kavas
kivas124614735___kivas
kopiykas164805kopiykas
kvas117015945____kvas
larvas9310235__larvas
lavas85422225___lavas
lezzes14387835lezz__es
lezzies1536205lezz_ies
lezzy16608085lezzy___
lycras11287245ly__cras
lysozymes2651795lysozymes
lyssas935445ly__ssas
lyttas985075ly__ttas
matzas1749695matz__as
mayas105924385__may_as
mazumas2034615_mazumas
mazurkas2372365mazurkas
mazzards1943935mazzards
mezuzas1743235_mezuzas
mezzos1635045mezz__os
mirzas1738175mirz__as
mitzvah2441765mitz_vah
mitzvahs2541295mitz_vahs
mizunas1843685_mizunas
mizzens17366115mizz_ens
mizzles17329475mizz_les
mozettas1993535mozettas
mozzettas1951775mozzettas
muzzlers18245195muzzlers
muzzles17299675muzz_les
muzzy188410595muzzy___
myalgias14123875myalgias
myelomas1544325myelomas
mynas105815235___mynas
myomas1338295my__omas
myopias14308105my_opias
myricas1436725my_ricas
myxomas2153905my_xomas
novas85215365___novas
nozzles15276295nozz_les
nuzzlers16244745nuzzlers
nuzzles15298115nuzz_les
nyalas936905ny__alas
ottavas1093485_ottavas
oyezes1835055oyez__es
palmyras1544035palmyras
papayas1437275papay_as
pavlovas1642415pavlovas
piasavas1343325piasavas
piazzas1743645piaz_zas
pirayas1277485piray_as
pitayas1286255pitay_as
pizza1538185pizz__a_
pizzaz1565445pizz__az
pizzazes1752515pizzazes
pizzerias1942165pizzerias
pizzles17329265pizz_les
playas114612275_play_as
plazas17409905plaz__as
pozzolan1892665pozzolan
pozzolans19131985pozzolans
puzzlers18295135puzzlers
puzzles17318965puzz_les
pyaemias1545065pyaemias
pyas96225705___py_as
pyemias1436805py_emias
pyjamas21263525py_jamas
pyrexias20224995pyrexias
pyrolas1239835py_rolas
pyurias1236705py_urias
rayas85922045__ray_as
razzes144910055razz__es
rozzers1535635rozz_ers
ryas77224615___ry_as
salivas10309605_salivas
selvas93812915__selvas
shivas124512405__shivas
silvas92912185__silvas
sizzlers16274745sizzlers
sizzles15349625sizz_les
soyas84520915__soy_as
sylva11268445sy__lva_
sylvae12236865sy__lvae
sylvan12257365sy__lvan
sylvans13235875sy__lvans
syngas10368915sy__ngas
synovias1445295synovias
syringas12285925syringas
syzygial2451435syzygial
syzygies2441345syzygies
syzygy2141115sy_zy_gy
tazza1338085tazz__a_
thuyas1234775_thuy_as
tizzies15287885tizz_ies
tizzy16548885tizzy___
ulvas84511505___ulvas
vas67755775_____vas
vivas114815015___vivas
vizslas1943145_vizslas
volvas12447995__volvas
vulvas12388845__vulvas
wizzens18385475wizz_ens
wizzes175110775wizz__es
xylyls1931835xy_ly_ls
yantras10259005_yantras
yautias1046325_yautias
yays105728915_y_ay__s
yeas78638425____yeas
yentas94614215_y_entas
yerbas11119285_y_erbas
yeshivas1742045yeshivas
yogas96615605_y__ogas
yttrias1044495_yttrias
yucas106013915_y__ucas
yuccas13426555_y_uccas
yugas95012065_y__ugas
zamarras1943775zamarras
zamias174212895__zamias
zananas16319525z_ananas
zanza1378705zanz__a_
zarebas1836285z_arebas
zareebas1943095zareebas
zaribas1836005z_aribas
zarzuelas175935zarzuelas
zas126946835___z__as
zayins18409695__zayins
zazens1435815z_az_ens
zebras1737855__zebras
zelkova2341585zelkova_
zemstva2141585zemstva_
zemstvos2261155zemstvos
zenaidas18513645zenaidas
zenanas16286225z_enanas
zephyrs2441945zephy_rs
zetas145018165___zetas
zeugmas1942545z_eugmas
zigzag1642965zigz__ag
zigzags1742275zigz_ags
zinnias1635855z_innias
zizzle13247305zizz__le
zizzled15315845zizz_led
zizzling16233925zizzling
zlotys18374175zloty__s
zoeas145815615___zoeas
zonulas1637015z_onulas
zoogleas1843375zoogleas
zorillas1745465zorillas
zouaves1933895z_ouaves
zoysias1943835z_oysias
zydecos2241895zy_decos
zygoma2143485zy_goma_
zygoses20436775zy_goses
zygosis20405945zy_gosis
zygotes20355145zy_gotes
zymase201997475___zymase
zymases21938335zy_mases
zymes1924712945___zymes
zymogens2343675zymogens
zymogram2554405zymogram
zymograms2643865zymograms
zymolyses2643125zymolyses
zymolysis2653045zymolysis
zymosan2143805zy_mosan
zymosans2243225zymosans
zymoses21608685zy_moses
zymosis21487475zy_mosis
zzz1017911915z_zz____

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 Filter1786911703740.1561145455.1
2DLD Change Limit17037427415.68610861.5
3Display Results2742740.0932946.2
 (SQL Overall)17869127415.93511213.7
 
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.