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

342 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
gyoza183611(None) 
gyozas1933601gyozas
gloze154815982gloze
goa47343802g_o_a
myoma1239272myoma
yoga87418052_yoga
aboma91114603aboma
adoze155713833adoze
agora6914333agora
aloha8513613aloha
anoa45634473ano_a
aroma71220143aroma
baiza164813223baiza
biota74516823biota
boa56954033_bo_a
bola66035563_bola
booze164718913booze
boozy194917063boozy
bora66141633_bora
bota66236503_bota
boyla102912363boyla
bozo156821413_bozo
braza165214253braza
chola104718033chola
cloze165517543cloze
coca88030643_coca
coda77029343_coda
cola66541393_cola
colza165112983colza
coma87134853_coma
coxa136922963_coxa
coz149345363_coz_
cozy185823803_cozy
croze164719453croze
cyma116715843cy_ma
dona55529633_dona
doozy186813713doozy
dopa77220903_dopa
doze145829083_doze
dozy175920323_dozy
eyra76217553ey_ra
flora85317103flora
flota85315643flota
fora75937393_fora
fozy197017163_fozy
froze174515653froze
gaga66625553g_aga
gala55635163g_ala
galea64722933galea
gama77035513g_ama
gamba106018513gamba
gamma106116103gamma
ganja131410003ganja
gaol56925413gao_l
gaols66717573gaols
garda7316763garda
gauze155712973gauze
gauzy18489213gauzy
gazar154612983g_azar
gaze145032413g_aze
gazoo153112873gazoo
geez146424863geez_
gemma106311773gemma
genoa64315823genoa
genua64614153genua
geode7412593geode
geoid74215753geoid
geta56627443g_eta
ghazi1837433ghazi
ghost96318763ghost
ghoul959053ghoul
giga66720943g_iga
ginzo1539613ginzo
glaze155418163glaze
glazy187410983glazy
gleba83910243gleba
glia56423153g_lia
glioma935953glioma
gloam86015943gloam
gloat65427683gloat
glob76623393glo_b
global937663global
globe84917013globe
globs85616403globs
glogg837353glogg
glom75424383glo_m
gloms85219783gloms
gloom87116523gloom
glop76724633glo_p
glops85619553glops
gloria71910543gloria
glory96413293glory
gloss64319623gloss
glossa7529163glossa
glost65422933glost
glout65925813glout
glove94516293glove
glow85222523glo_w
glows95518033glows
glozed173711223glozed
glozes164313353glozes
gnome84213953gnome
go38748743g_o__
goad66830983g_oad
goal55829303g_oal
goas55239943g_oas
goat56250833g_oat
gob68950893g_o_b
goban84414073g_oban
gobo76126893g_obo
gobs76935573g_obs
goby106021083g_oby
god57449793g_o_d
gods65438043g_ods
goer56827103g_oer
goes55644093g_oes
gogo69722833g_ogo
gold65430163g_old
golf85731183g_olf
gonad75216053g_onad
gone55639043g_one
gong66827193g_ong
gonia64117533gonia
gonzo15310243gonzo
goo47754773g_o_o
good66531803g_ood
goods75124483goods
goody105620393goody
gooey95522863gooey
goof85436873g_oof
goofs94821003goofs
goofy124915623goofy
gook96429603g_ook
gooks105422883gooks
gooky135818033gooky
goon57236173g_oon
goons65326773goons
goony95519783goony
goop75829483g_oop
goops86620963goops
goopy115816623goopy
gooral7310463gooral
goos57644913g_oos
goose65925903goose
goosy96018883goosy
gor47848263g_o_r
goral65125753g_oral
gore55744963g_ore
gorm75529393g_orm
gorp75625903g_orp
gory86129663g_ory
gos47155133g_o_s
gosh86123423g_osh
got49870443g_o_t
goth86825083g_oth
gout56646003g_out
gowan95415743g_owan
gowd96519983g_owd
gowk125516473g_owk
gown85724073g_own
gox117137183g_o_x
goy77844553g_o_y
goyim1148593goyim
goys86328413g_oys
grama85620283grama
grana65722093grana
graze155820053graze
groan65618423groan
groat65531973groat
grody103412063grody
grog65923343gro_g
grogs76319413grogs
groin65521083groin
grok95819683gro_k
groks105716123groks
groom85317983groom
grope84821613grope
gross65421693gross
grosz154814093grosz
grosze16457733grosze
groszy19395703groszy
grot55942053gro_t
grots65025853grots
group85413923group
grout65330423grout
grove95219333grove
grow86127303gro_w
growl96115823growl
grown95317353grown
grows95523923grows
guava938583guava
gumma105313103gumma
gutta64613383gutta
guyot9314523guyo_t
guyots1036003guyots
gybe105916243gy_be
gybed125811023gybed
gybes115012723gybes
gym95719063gy__m
gyms107514593gy_ms
gyp98319013gy__p
gyps105115023gy_ps
gypsy14636993gypsy
gyral94412783gyral
gyre84722763gy_re
gyred105114093gyred
gyres94820323gyres
gyri85415153gy_ri
gyro85217883gy_ro
gyron95314623gyron
gyrons105511223gyrons
gyros95616483gyros
gyrose105310253gyrose
gyrus95310803gyrus
gyttja1741573gyttja
gyve116215083gy_ve
gyved13568743gyved
gyves125711553gyves
hamza19139773hamza
hooka125513903hooka
hora76136553_hora
hoya107418373_hoya
huzza1646093huzza
hydra12249223hydra
hyena11810253hyena
hyla106716513hy_la
hyoid12612423hyoid
hypha1637383hypha
iota45127833_iota
ixora1236913ixora
jota116423623_jota
koa76737773_ko_a
kola85124963_kola
kora86431553_kora
krona93611793krona
loca65527683_loca
loofa85912813loofa
lota47233503_lota
lycea10418943lycea
lycra10317973lycra
lyssa835713lyssa
lytta888063lytta
matza16311813matza
mirza16410443mirza
moa57249183_mo_a
mola66035633_mola
moola75117033moola
mora66641273_mora
moxa136917743_moxa
mozo157719743_mozo
myna95815293my_na
myoid11512983myoid
myomas1338293myomas
myope124010973myope
myopia13318433myopia
myopy15457353myopy
myxoma2043943myxoma
noma67529463_noma
nona46929063_nona
nota46830773_nota
nova76518953_nova
nyala836823nyala
oba57531553__oba
oca56731733__oca
oda48133043__oda
oka76926803__oka
ooze136420603_ooze
oozy167018133_oozy
ora37250833__ora
ova66823793__ova
oyez166020353oyez_
payola11208113payola
pizza1538183pizza
plaza164311063plaza
proa66229963pro_a
pya87023753py__a
pyoid11513753pyoid
pyrola1139003pyrola
quota145111963quota
rioja1236303rioja
rota45834343_rota
rya67622013ry__a
ryokan1353753ryokan
ryot75528563ryo_t
ryots85313783ryots
soba64927923_soba
soca66330053_soca
soda56329383_soda
sofa75625603_sofa
soja115619513_soja
sola45541863_sola
soma65635293_soma
sora45746913_sora
soya75724433_soya
stoa45425913sto_a
stoma75918273stoma
sylva11268443sylva
tazza1338083tazza
toea46732333_toea
toga57027413_toga
tola45236333_tola
tora47545993_tora
trona54118953trona
viola85915543viola
whoa106615203who_a
woozy204410603woozy
ya510251503_y__a
yea66445753_y_ea
yo59748553_yo__
yob87945273_yo_b
yobs96028083_yobs
yock135924613_yock
yod77545503_yo_d
yodh119916103_yodh
yods86531183_yods
yogas96615603_yogas
yogh116616143_yogh
yogi86120423_yogi
yok107335243_yo_k
yoke115626393_yoke
yoks116223743_yoks
yolk116218993_yolk
yom88043443_yo_m
yon67348953_yo_n
yond86122313_yond
yoni77524393_yoni
yore76335943_yore
you66641823_yo_u
your78623433_your
yous76230653_yous
yow96945293_yo_w
yowe106728743_yowe
yowl105820953_yowl
yows106433123_yows
yuca95716723_yuca
yuga85615423_yuga
za1114939203___za
zanza1378703zanza
zoa128529993_zo_a
zoea137118423_zoea
zona136321963_zona
zygoma2143493zygoma

Search took 4 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 Filter178691836670.1101624463.6
2DLD Change Limit836673423.34325027.5
3Display Results3423420.0933677.4
 (SQL Overall)1786913423.54650392.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.