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

512 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
zanzas148705(None) 
zanza1378701zanza_
anas46649862_an_as
angas65827982_angas
anlas55626932_anlas
annas55824882_annas
anoas57226492_anoas
antas55432032_antas
baizas173810822baizas
bandas95120542bandas
banzai1737652banzai
banzais1837162banzais
cannas84518402cannas
canvas113813332canvas
fangas105017192fangas
ganjas14149112ganjas
hamzas20119012hamzas
hansas94616042hansas
kanas95326912kan_as
kanzus1944602kanzus
kwanzas2342052kwanzas
manas76240422man_as
mangas94122922mangas
manias84029032manias
mannas85019802mannas
mantas85725362mantas
matzas1749702matzas
nanas55928632nan_as
pandas95521962pandas
pangas99921102pangas
sangas75222652sangas
stanzas1636362stanzas
tankas104613762tankas
tazzas1436272tazzas
vandas103915992vandas
zamias174212922zamias
zananas16319562zananas
zanies153219672zanies
aas310975393_a__as
abas68642083_a_bas
abbas95918643_abbas
adzes155913803_adzes
agas55938843_a_gas
aghas97014873_aghas
agmas85919873_agmas
alas46358123_a_las
albas75925393_albas
alfas87219043_alfas
algas65624933_algas
alias55834603_alias
almas76629773_almas
amas67746293_a_mas
amias75831463_amias
ana39559823_an_a_
anabas8314083_anabas
anal48037523_an_al
ands57833613_an_ds
anear55420323_anear
anears63717183_anears
anes45255933_an_es
anga56831353_anga_
anils56326723_anils
animas84418723_animas
anis45746463_an_is
ankhs12116723_ankhs
ankus91410683_ankus
anna45529013_anna_
annal56520763_annal
annals66415923_annals
anoa45634473_anoa_
ansa45927773_ansa_
ansae55720973_ansae
anta46839583_anta_
antae56828293_antae
antes56334323_antes
antis55033313_antis
ants47243473_an_ts
anus47131113_an_us
apneas83211383apneas
aquas142412613_aquas
areas55935773_areas
arias55438023_arias
arras55626133_arras
asanas6514113asan_as
atlas55821583_atlas
atmas75721013_atmas
auras55932553_auras
avgas96912133_avgas
azaleas1636993azaleas
azan136521783_a_zan
azans146516883_a_zans
baas66844673ba__as
babas96325733ba_bas
babkas146010143babkas
baiza164813223baiza_
baizes174315053baizes
balas76937213ba_las
balsas86417523balsas
banal75925993ban_al
bananas93312223bananas
bancos104713893bancos
banda85223103banda_
bands85233423ban_ds
banes74945583ban_es
bangs85627773ban_gs
banian8315383banian
banians9312033banians
banjax2234763banjax
banjos15378893banjos
banks115527903ban_ks
banns75321233ban_ns
bans66555133ban__s
bantam10314063bantam
bantams1149063bantams
banyan1139483banyan
banyans1237913banyans
barcas101016603barcas
bazar163816003ba_zar
bazars174613113ba_zars
benzal1739643benzal
bonanzas1943113bonanzas
bonzes175116103bonzes
brazas175812433brazas
bunas75126573bun_as
bunyas11359433bunyas
bwanas1157443bwan_as
cacas95627983ca_cas
cadenzas2053743cadenzas
callas84526753callas
camas96333523ca_mas
canal75428043can_al
canals84421663canals
cancan10314103cancan
cancans11311873cancans
canchas143212403canchas
caners84629193caners
canes75350373can_es
canids95118133canids
canna75919333canna_
canoes84725883canoes
canolas9313993canolas
canons85522063canons
cans65050843can__s
cansos84915383cansos
cantal84122033cantal
cantals93919573cantals
cantos84826973cantos
cants77036943can_ts
cantus85117763cantus
canulas9312853canulas
canvass12376873canvass
canzonas1935383canzonas
capias10318353capias
casas75327843ca_sas
centas85020703centas
colzas174010503colzas
congas94417033congas
czardas1934673czardas
dachas124113253dachas
dadas75819863da_das
daggas937973daggas
dances95120653dances
dangs75623203dan_gs
danios7314603danios
dans56748143dan__s
dazes155024143da_zes
donas65926473don_as
dongas84914613dongas
donnas75511323donnas
etnas54713933etn_as
facias113415803facias
faenas94412763faenas
fanegas1145713fanegas
fanes84639893fan_es
fanga96119623fanga_
fangs96224073fan_gs
fanons96115213fanons
fanos85926503fan_os
fans76247363fan__s
fantasm1236593fantasm
fantast10311703fantast
fantasy1336153fantasy
fanums1137263fanums
fatwas1249053fatwas
faunas94013633faunas
favas115618593fa_vas
fazes175527213fa_zes
fincas113512073fincas
galas65731643ga_las
galeas74618503galeas
gamas85431353ga_mas
gambas115817513gambas
gammas115714693gammas
ganefs10489203ganefs
ganevs10456913ganevs
gangs76222573gan_gs
ganja131410003ganja_
ganjah17145493ganjah
ganjahs18104003ganjahs
ganofs104010293ganofs
gauzes164710633gauzes
gazanias1845733gazanias
gazar154612983ga_zar
gazars164811553ga_zars
gazes155425913ga_zes
genoas74013623genoas
goannas836223goannas
gyozas1933603gyozas
hahas117118443ha_has
halmas117017893halmas
halvas124714173halvas
hamza19139773hamza_
hamzah23135553hamzah
hamzahs24134373hamzahs
hances115621283hances
handax1749583handax
hands95327383han_ds
hangar104114503hangar
hangars114313483hangars
hangs95726723han_gs
hanks126226863han_ks
hansa85416783hansa_
hanses95022633hanses
hants86335403han_ts
hazan173813613ha_zan
hazans183411653ha_zans
hazes174928323ha_zes
hazzan17236803hazzan
hazzans18215783hazzans
hennas94211803hennas
hondas10313353hondas
huzzas1735863huzzas
jagras1438463jagras
janes124928123jan_es
javas155915423ja_vas
jazzes21347883jazzes
jnanas13207303jnanas
juntas134210503juntas
kaas86531843ka__as
kakas85117343ka_kas
kalpas124112943kalpas
kana85928523kan_a_
kanakas10327213kanakas
kanban1238623kanban
kanbans1337723kanbans
kanes95529373kan_es
kanjis1735963kanjis
kantar10311153kantar
kantars11310033kantars
kanzu1847593kanz_u
kapas116021733ka_pas
kappas144410363kappas
karmas123013733karmas
kashas133311903kashas
katas95922093ka_tas
kavas125919953ka_vas
kinas95626913kin_as
kwanza2232473kwanza_
lamas75532793la_mas
lamias85020613lamias
lampas106615953lampas
lanai5319573lan_ai
lanais6316793lanais
lances84824103lances
landau7310613landau
landaus8310343landaus
lands65426903lan_ds
lanes54946793lan_es
larvas9310233larvas
lauras63414333lauras
lavas85422223la_vas
lazar144113643la_zar
lazars153812393la_zars
lazes145129573la_zes
lianas63713383lian_as
lingas75116563lingas
lunas55025013lun_as
madras94316423madras
mafias113913573mafias
magmas115512503magmas
maizes175115733maizes
mamas95930773ma_mas
mambas125716243mambas
mammas94616403mammas
mana65341943man_a_
mananas93414733mananas
manat76039983man_at
manats84623463manats
manes76648953man_es
manga85026193manga_
manges94628943manges
mangos94319333mangos
mania75634143mania_
maniac103917973maniac
maniacs114313063maniacs
manics103919933manics
manilas93915873manilas
manna75522533manna_
mannan85413623mannan
mannans93611523mannans
manors84420883manors
manos74933613man_os
mans66354533man__s
manses84225513manses
manta75629903manta_
mantes84430783mantes
mantis83926033mantis
mantras93815863mantras
mantuas93410993mantuas
manual8313463manual
manuals9311213manuals
manus75924923man_us
maras75443283ma_ras
markas124717003markas
masas75630413ma_sas
massas85116463massas
matza16311813matza_
matzah2035963matzah
matzahs2134483matzahs
matzos1749263matzos
mayas105924383ma_yas
mazes165632173ma_zes
mensas85115853mensas
minas75434113min_as
mirzas1738173mirzas
monas74732153mon_as
mynas105815233myn_as
nachas114914193nachas
nadas66320813na_das
nairas6312773nairas
nakfas1334683nakfas
nalas55528363na_las
nana46632893nan_a_
nances83618643nances
nans46139393nan__s
napas75924353na_pas
nappas105511613nappas
nazis145216083na_zis
ninjas1386303ninjas
nonas55126653non_as
organzas1853263organzas
pacas96029403pa_cas
pachas135017143pachas
paisas84317493paisas
pampas124913993pampas
panadas103312213panadas
panamas113112753panamas
panda85022613panda_
panels84716523panels
panes76148693pan_es
panga85323533panga_
pangs84628663pan_gs
panics103815363panics
pannes85522853pannes
pans65855723pan__s
pantos85222743pantos
pants76536923pan_ts
panzer174213233panzer
panzers184012013panzers
papas94927493pa_pas
paras76143043pa_ras
parkas125018023parkas
pashas115117063pashas
pastas85422873pastas
piazzas1743643piazzas
pinas75434453pin_as
pinnas85315513pinnas
pintas85021393pintas
pizzas1646983pizzas
plazas17409913plazas
punas74826753pun_as
punkas123410673punkas
qanat144426843qan_at
qanats154112813qanats
ragas65326063ra_gas
raias54631123ra_ias
raitas64417673raitas
rajas127317723ra_jas
rances84625443rances
randan7315253randan
randans8313213randans
rands65930453ran_ds
ranees64623963ranees
ranges73826923ranges
ranids75118703ranids
ranis55235833ran_is
ranks95225733ran_ks
rants55935343ran_ts
ranulas7311773ranulas
rayas85922053ra_yas
razes145032703ra_zes
razzes144910063razzes
ruanas6311263ruan_as
sabras85116363sabras
sagas66025883sa_gas
saigas74114293saigas
salpas85116923salpas
salsas65316133salsas
sambas104219263sambas
sandal73317283sandal
sandals82715203sandals
sands65228583san_ds
sanes55649073san_es
sanga66023793sanga_
sangar73617683sangar
sangars83116253sangars
sanghs105312063sanghs
sanies63031953sanies
sanjak1735693sanjak
sanjaks1834963sanjaks
sans45153353san__s
sansar63613393sansar
sansars73313913sansars
santos64421833santos
saunas63915433saunas
sennas64214233sennas
stanza1537073stanza_
sunnas63914563sunnas
syngas10368913syngas
tablas83716163tablas
taenias7311283taenias
tafias93111963tafias
taigas73712553taigas
takas95520683ta_kas
talas55935893ta_las
tanga64923683tanga_
tangos74216303tangos
tangs65028343tan_gs
tanka93817483tanka_
tanks94624733tan_ks
tans46154813tan__s
tantras73112093tantras
tapas74627713ta_pas
tarzan152910753tarzan
tarzans16329923tarzans
tazza1338083tazza_
tenias64720073tenias
tineas64616473tineas
tongas74315513tongas
tunas54224123tun_as
ulnas55716533uln_as
uranias72113813uranias
usneas638333usneas
vanda94515923vanda_
vandal103713833vandal
vandals113211663vandals
vanes85130973van_es
vangs96319583van_gs
vanman1139793vanman
vans76236723van__s
varas86028193va_ras
varias95019903varias
varnas94212823varnas
vinas85126343vin_as
vincas113912453vincas
wallas95719393wallas
wands96425483wan_ds
wanes85040883wan_es
wangan10311223wangan
wangans1149503wangans
wanks126124483wan_ks
wans76452263wan__s
wants87932213wan_ts
winzes184313053winzes
xenias133712973xenias
yangs95618693yan_gs
yanks125316573yan_ks
yantras10259003yantras
yentas94614213yentas
zaffar21385043zaffar
zaffars22325233zaffars
zags146826683za__gs
zaikai1943713zaikai
zaikais2042913zaikais
zaires1539703zaires
zamia165115213zamia_
zanana153810363zanana
zander163417113zander
zanders173015793zanders
zanier154314713zanier
zaniest163214773zaniest
zanily18310183zanily
zany167316983zan__y
zanyish2235903zanyish
zaps156826893za__ps
zarebas1836303zarebas
zarfs174713623za_rfs
zaribas1836043zaribas
zas126946833___zas
zaxes215113823za_xes
zayins18409713zayins
zazen1337283za_zen
zazens1435833zazens
zebras1737853zebras
zenanas16286233zenanas
zetas145018163z_etas
zigzag1642963zigzag
zigzags1742273zigzags
zincs165312933zin_cs
zinebs17606803zinebs
zines145232653zin_es
zings154620893zin_gs
zinnias1635863zinnias
zins135735003zin__s
zoeas145815613z_oeas
zona136321963zon_a_
zonae145116443zon_ae
zonal145116853zon_al
zoners155115993zoners
zones145528043zon_es
zonks184815173zon_ks
zonulas1637023zonulas

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.1531167915.0
2DLD Change Limit1127165126.28317939.8
3Display Results5125120.1563282.1
 (SQL Overall)1786915126.59227107.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.