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

175 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
zenanas1628623(None) 
zananas16319561zananas
zenana15297981zenana_
bananas93312222bananas
hennas94211802hen_nas
jnanas13207302_jnanas
mananas93414732mananas
nanas55928632__nanas
penangs10268372penangs
sennas64214232sen_nas
tenants7311012tenants
zanana153810362zanana_
zenaidas18513652zenaidas
anabas8314083_anabas
anas46649863___anas
annas55824883_an_nas
annonas738793annonas
asanas6514113_asanas
banana83213413banana_
bandanas11178573bandanas
beanos85516513be_anos
beans75734693be_an_s
benames112814603benames
bennes86019013ben_nes
bennis84314803ben_nis
bezants1877343bezants
bonanzas1943113bonanzas
bwanas1157443_bwanas
cabanas112413033cabanas
cannas84518403can_nas
centas85020703cen_tas
cetanes9315133cetanes
deans66131393de_an_s
decanal1038113decanal
decanes103118913decanes
decants103514443decants
dedans85915073dedan_s
defangs1235363defangs
demands114311413demands
denars74621433dena_rs
desands94810163desands
dewans105215143dewan_s
donnas75511323don_nas
duennas834143duen_nas
elands74914773_elands
elans55527753_elan_s
enacts84012973_enacts
enates64026423_enates
encinas938723_encinas
enemas8812003_enemas
etnas54713933_e_tnas
fenlands1245183fenlands
geladas936313geladas
gelants82611443gelants
genevas1185253genevas
genoas74013623gen_oas
goannas836223goannas
henbanes1336563henbanes
henna84414043hen_na_
hexanes17319463hexanes
honans94814503honan_s
iguanas835373iguanas
ikebanas1442333ikebanas
inanes62519803_inanes
jacanas1638263jacanas
jeans126022113je_an_s
jnana12159043_jnana_
kanakas10327213kanakas
kanas95326913__kanas
kenafs1337113kena_fs
kinaras1159093kinaras
lantanas838263lantanas
leans55536253le_an_s
lemans85316393leman_s
levants1037723levants
lianas63713383_lianas
manana84816073manana_
manas76240423__manas
mannas85019803man_nas
means75831223me_an_s
medakas1435763medakas
medinas103411463medinas
melenas999203melenas
menaces112715523menaces
menads95514383mena_ds
menages103615393menages
mensas85115853men_sas
naans55815253__naans
nadas66320813__nadas
naganas847983naganas
nalas55528363__nalas
nana46632893__nana_
nans46139393__nan_s
napas75924353__napas
nonas55126653__nonas
panadas103312213panadas
panamas113112753panamas
peans75437643pe_an_s
pecans101515833pecan_s
pedants10310113pedants
pekans121710553pekan_s
penance11313443penance
penances12312443penances
penang92511113penan_g
penates93321593penates
pendants1139093pendants
penna74520203pen_na_
pennae84314033pen_nae
pennants1037063pennants
pennis84315743pen_nis
pentanes10316073pentanes
pinangs10267793pinangs
pinatas93711483pinatas
pinnas85315513pin_nas
piranas9912603piranas
puranas9712643puranas
reatas64021013re_atas
recanes93222263recanes
recants93217093recants
redans75421023redan_s
reginas85614063reginas
rehangs1137563rehangs
relands85214883relands
remands104914883remands
remans84823003reman_s
remnants1036843remnants
renails74917263renails
renames92418053renames
renins64526453renin_s
rennase738713ren_nase
retinas74819353retinas
ruanas6311263_ruanas
secants93413893secants
sedans74816093sedan_s
senates73322583senates
senecas939013senecas
senegas837253senegas
senna54617983sen_na_
senoras72714953senoras
sewans95215903sewan_s
siennas736123sien_nas
sonants7511233sonants
sonatas7510293sonatas
sunnas63914563sun_nas
tenaces92814513tenaces
tenails73713923tenails
tenancy1237503tenancy
tenant6322473tenan_t
tenias64720073ten_ias
tennis64015303ten_nis
tenons62916603tenon_s
tetanal738023tetanal
tetanus737933tetanus
veenas91410413ve_enas
vegans103910853vegan_s
venenes102712133venenes
venines103516613venines
venins93816703venin_s
verandas1246233verandas
weans85326743we_an_s
xenias133712973xen_ias
xenons132710483xenon_s
yeans86624883ye_an_s
yentas94614213yen_tas
zanzas1487053zan_zas
zeals145320853ze_a_ls
zebranos1943703zebranos
zebras1737853ze_bras
zeins144715393ze_in_s
zenaida17914783zenaida
zeniths1935153zeniths
zetas145018163ze__tas
zeugmas1942543zeugmas
zinnias1635863zinnias
zonulas1637023zonulas

Search took 9 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271757.80017182.9
3Display Results1751750.0602916.7
 (SQL Overall)1786911758.01322300.1
 
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.