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

271 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
gyozas193360(None) 
gyoza1836111gyoza_
glozes164313352glozes
goas55239942g_o_as
myomas1338292myomas
yogas96615602_yogas
abomas101113583abomas
agoras7613343agoras
alohas9411703alohas
anoas57226493ano_as
aromas81018613aromas
baizas173810823baizas
biogas94310913biogas
biotas84313923biotas
boas66150833_bo_as
bolas74733763_bolas
boozes174916523boozes
boras75938303_boras
botas75328783_botas
boylas113011723boylas
bozos165216863_bozos
brazas175812433brazas
cholas114817993cholas
clozes174915563clozes
cocas95926573_cocas
codas84724243_codas
colas75436773_colas
colzas174010503colzas
comas95833003_comas
cozes166033243_cozes
crozes174417663crozes
cycas126513823cy_cas
cymas126417883cy_mas
donas65926473_donas
dopas85019063_dopas
dozes155226303_dozes
eyas76427433ey__as
eyras84715923ey_ras
floras94715693floras
flotas94013003flotas
galas65731643g_alas
galeas74618503galeas
gamas85431353g_amas
gambas115817513gambas
gammas115714693gammas
ganjas14149113ganjas
gaols66717573gao_ls
gas48870253g___as
gauzes164710633gauzes
gazar154612983g_azar
gazars164811553g_azars
gazes155425913g_azes
gazoos163010223gazoos
genoas74013623genoas
geodes8412153geodes
geoids8369843geoids
getas65421483g_etas
ghazis1935193ghazis
ghosts10489273ghosts
ghouls1036043ghouls
gigas75415583g_igas
glazes165315643glazes
glias64618493g_lias
gliomas1035333gliomas
gloam86015943glo_am
gloams95210663gloams
gloat65427683glo_at
gloats74515423gloats
global937663global
globes94314543globes
globs85616403glo_bs
gloggs935033gloggs
gloms85219783glo_ms
glomus9468093glomus
glooms96211683glooms
glops85619553glo_ps
glorias81610313glorias
gloss64319623glo_ss
glossa7529163glossa
glossas8438193glossas
glosts74513813glosts
glouts74414713glouts
gloves104115183gloves
glows95518033glo_ws
gloze154815983gloz_e
glozed173711223glozed
gnomes93812973gnomes
gnoses76515163gnoses
gnosis75711213gnosis
goa47343803g_o_a_
goad66830983g_o_ad
goads77022853g_oads
goal55829303g_o_al
goals65521293g_oals
goat56250833g_o_at
goats65527303g_oats
goban84414073g_oban
gobans94412043g_obans
gobos86219373g_obos
gobs76935573g_o_bs
gods65438043g_o_ds
goers65520253g_oers
goes55644093g_o_es
gogos77516523g_ogos
golds75421313g_olds
golfs95616103g_olfs
gonad75216053g_onad
gonads84511733g_onads
gongs74921613g_ongs
goods75124483g_oods
goofs94821003g_oofs
gooks105422883g_ooks
goons65326773g_oons
goops86620963g_oops
gooral7310463gooral
goorals838703goorals
goos57644913g_o_os
gooses75723053gooses
goral65125753g_oral
gorals76917653g_orals
gores65740373g_ores
gorms85619593g_orms
gorps85316993g_orps
gos47155133g_o__s
goths96513003g_oths
gouts64826173g_outs
gowan95415743g_owan
gowans105512293g_owans
gowds105814043g_owds
gowks136011953g_owks
gowns95115103g_owns
goxes135018263g_oxes
goys86328413g_o_ys
gramas94317203gramas
grazes164519643grazes
groan65618423gro_an
groans74815063groans
groat65531973gro_at
groats74816653groats
grogs76319413gro_gs
groins73917203groins
groks105716123gro_ks
grooms94512523grooms
gropes95220403gropes
gross65421693gro_ss
grots65025853gro_ts
groups94210513groups
grouts75015613grouts
groves104318103groves
growls104711113growls
grows95523923gro_ws
guavas1037153guavas
gummas114810513gummas
guyots1036003guyo_ts
gybes115012723gy_bes
gymnast1344153gymnast
gyms107514593gy__ms
gyps105115023gy__ps
gyral94412783gy_ral
gyrase10508773gy_rase
gyres94820323gy_res
gyrons105511223gyrons
gyros95616483gy_ros
gyrus95310803gy_rus
gyttjas1841003gyttjas
gyves125711553gy_ves
hamzas20119013hamzas
hookas135312493hookas
horas86333093_horas
hoyas115016163_hoyas
huzzas1735863huzzas
hydras13239313hydras
hyenas1288953hyenas
hylas114815903hy_las
hyoids1377673hyoids
iotas54821113_iotas
ixoras1337193ixoras
jotas125717443_jotas
koas85635093_ko_as
kolas94822233_kolas
koras95927113_koras
loofas9429833loofas
lotas55926303_lotas
lycras11287243lycras
lyssas935443lyssas
lyttas985073lyttas
matzas1749703matzas
mirzas1738173mirzas
moas65545343_mo_as
molas75132093_molas
monas74732153_monas
moolas83615593moolas
moras76438763_moras
moxas145014393_moxas
mozos165516333_mozos
mynas105815233my_nas
myoma1239273myoma_
myopes13419963myopes
myopias14308143myopias
myoses114013843myoses
myosis114012553myosis
myxomas2153903myxomas
nomas74726413_nomas
nonas55126653_nonas
novas85215363_novas
nyalas936903nyalas
obas65730933__obas
ocas66729633__ocas
odas57230263__odas
okas85225393__okas
oozes145418713_oozes
oyezes1835053oyezes
payolas12148973payolas
pizzas1646983pizzas
plazas17409913plazas
proas75028803pro_as
psoas75012983pso_as
pyas96225703py__as
pyoses114314303pyoses
pyosis114012123pyosis
pyrolas1239863pyrolas
quotas15339433quotas
riojas1335813riojas
rotas54827723_rotas
ryas77224613ry__as
ryokan1353753ryokan
ryokans1443293ryokans
ryots85313783ryo_ts
sobas74424253_sobas
socas74026183_socas
sodas64123543_sodas
sofas85320713_sofas
sojas124716393_sojas
somas76030373_somas
soras55041013_soras
soyas84520913_soyas
stoas55126023sto_as
stomas84816323stomas
sylvas12288173sylvas
syngas10368913syngas
tazzas1436273tazzas
toeas55726423_toeas
togas67823003_togas
tolas54532773_tolas
toras55540373_toras
tronas63816893tronas
violas93713523violas
yeas78638423_y_eas
yobs96028083_yo_bs
yocks144418373_yocks
yodhs12669013_yodhs
yods86531183_yo_ds
yoga87418053_yoga_
yoghs125410593_yoghs
yogis95617743_yogis
yokes125223023_yokes
yoks116223743_yo_ks
yolks125412773_yolks
yonis85020823_yonis
yores85031323_yores
yours85217873_yours
yous76230653_yo_us
yowes114926373_yowes
yowls115715433_yowls
yows106433123_yo_ws
yucas106013913_yucas
yugas95012063_yugas
zanzas1487053zanzas
zas126946833___zas
zoeas145815613_zoeas
zygomas2243413zygomas

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 Limit1127162716.31317854.6
3Display Results2712710.1701594.1
 (SQL Overall)1786912716.62326980.4
 
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.