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

300 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
nagana74894(None) 
naganas847981naganas
agama85815572_agama
angina7413132angina
asana5315482_asana
banana83213412banana
cabana103913562cabana
jacana1537932jacana
lagan66520342lagan_
lagans75717782lagans
laguna7127222laguna
manana84816072manana
naan47621932na_an_
naans55815252na_ans
nana46632892n__ana
natant6318732natant
organa789212organa
pagan86121162pagan_
pagans95717922pagans
vagina102710932vagina
zanana153810362zanana
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
aga410447233_ag__a
again65218113_again
agamas97413443_agamas
agapae9388043_agapae
agapai9456843_agapai
agape85614843_agape
agar58726413_aga_r
agars66120643_agars
agas55938843_aga_s
agate66525143_agate
agave95314033_agave
agaze156113663_agaze
agenda837253_agenda
agene65621583_agene
agent65829643_agent
aggada955203aggada
agha87417303_ag_ha
agin56132713_agin_
aging77026353_aging
agita6315423_agita
agma77623263_ag_ma
agon56531883_agon_
agonal7410053_agonal
agone65924553_agone
agons66423783_agons
agony96415653_agony
agora6914333_agora
agria65517143_agria
alan46844083_alan_
aland65526413_aland
alane56135613_alane
alang66023513_alang
alans55636173_alans
alant55742293_alant
amarna839793_amarna
ana39559823___ana
anabaena1042663anabaena
anga56831353ang__a
angaria8311553angaria
angary10311323angary
angas65827983anga_s
anginal8310163anginal
anginas8310953anginas
angora71111573angora
anna45529013_a_nna
annona648873annona
arcana8912583arcana
arena55323813_arena
argala74712663argala
asanas6514113_asanas
avant86224663_avant
azan136521783_azan_
azans146516883_azans
bagass938933bagass
bagman114613813bagman_
balata8614673balata
bananas93312223bananas
bandana10179463bandana
began86319573began_
bogan87519003bogan_
bogans95714813bogans
bwana10310243_bwana
cabala103516913cabala
cabanas112413033cabanas
caging105321023caging
canna75919333ca_nna
caragana1146273caragana
carina84325323carina
casaba1079263casaba
casava1157873casava
catena8312473catena
choana1138443choana
dagga839543dag_ga
dagoba1074943dagoba
daman84821163daman_
damans94715983damans
damiana1046563damiana
faena85014203fa_ena
fagin9216573fagin_
fagins10513863fagins
farina94618233farina
fauna84816513fa_una
gaga66625553__gaga
gagaku1243813gagaku
gaging94718403gaging
gagman103811243gagman_
gala55635163__gala
galanga936013galanga
galena74911093galena
gama77035513__gama
gan48060123__gan_
gane55145293__gane
gang66031963__gang
ganja131410003__ganja
gazania1746113gazania
grana65722093_grana
guarana886303guarana
haggada1353623haggada
halala94715093halala
hamada1239913hamada
hariana10310243hariana
hawala12368913hawala
hazan173813613hazan_
hazans183411653hazans
hiragana1242883hiragana
hogan97817703hogan_
hogans105914313hogans
iguana735803iguana
jacanas1638263jacanas
jagra1338173jag_ra
japan14411233japan_
japans1539823japans
jarina134014063jarina
jawan15710383jawan_
jawans1657843jawans
jnana12159043_jnana
kabaka11348503kabaka
kabala124011553kabala
kabaya15387123kabaya
kahuna1394103kahuna
kamala12339963kamala
kana85928523__kana
kanaka9357523kanaka
labara83712893labara
lacuna8118123lacuna
lagend838743lagend
lagunas8156823lagunas
lagune7158633lagune
lamina84920443lamina
lantana739603lantana
lasagna843543lasagna
latina65621143latina
lauan55216793lauan_
lauans65113533lauans
liana53915893_liana
ligan67920283ligan_
ligand85011293ligand
ligans76817733ligans
logan68123283logan_
logania847833logania
logans76319063logans
magenta1038623magenta
magian9312833magian_
magians10310753magians
magma104513573mag_ma
magmata1237463magmata
malanga1036663malanga
mana65341943__mana
mananas93414733mananas
manna75522533ma_nna
maraca10314153maraca
maranta9311693maranta
marina84623413marina
masala8311813masala
mayan105616903mayan_
megara9310093megara
nada58022903n__ada
nadas66320813nada_s
nag46450813nag___
nagged93916053nagged
nagger84016123nagger
nagging102613043nagging
naggy106612823nag_gy
nags55436023nag__s
naiad6313403naia_d
naiads739013naiads
naira5314743na_ira
nakfa1236093na_kfa
nala46930393n__ala
nalas55528363nala_s
naming93917893naming
nan37854873n__an_
nanas55928633nana_s
nandina838913nandina
nanny84813813na_nny
nans46139393n__ans
napa66927263n__apa
napalm1047263napalm
napas75924353napa_s
nappa98511863na_ppa
narine63422553narine
nasal56217593nasa_l
nasals63312463nasals
natal53921493nata_l
nausea637313nausea
navaid1037643navaid
naval85315833nava_l
navar83912733nava_r
navars92810573navars
nawab10810923nawa_b
nawabs1185063nawabs
negate72915573negate
nirvana1042843nirvana
nomina83113683nomina
nona46929063n__ona
novena936763novena
numina83510843numina
nutant6316383nutant
nyala836823n_yala
organ6915393organ_
organs7912913organs
organza1793463organza
paean77222723paean_
paeans85118263paeans
pageant10312783pageant
paginal10269493paginal
paging104020403paging
pagoda10487873pagoda
paisana94010223paisana
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213343panama
papaya1337503papaya
parang93715513parang
pataca10311193pataca
patina86022193patina
pavan106518473pavan_
pavane114113443pavane
pavans115715593pavans
pirana8713263pirana
purana8712933purana
qabala17399193qabala
raga55930813rag__a
ragas65326063raga_s
raging85126433raging
raglan73711503raglan_
raglans82410133raglans
ragman94013713ragman_
ramada9310183ramada
ramona8412413ramona
ratan53722663ratan_
ratans63819373ratans
ratany93411873ratany
regina75317143regina
regna64614813reg_na
ruana5312423_ruana
saga55331173sag__a
sagaman10117553sagaman
saganash1243063saganash
sagas66025883saga_s
salina64221123salina
samara8313853samara
saran53730303saran_
sarans64224433sarans
sardana838643sardana
satang75711563satang
satara6315533satara
sauna54117553sa_una
savanna1043713savanna
savant9416043savant
signa66114703sig_na
taggant9310213taggant
tarama8412723tarama
tartana73010193tartana
unaging9510933unaging
vacant11415133vacant
vagal94613633vaga_l
vagary1337333vagary
vaginae11377683vaginae
vaginal11288403vaginal
vaginas11298813vaginas
vagrant11410663vagrant
varna84516173va_rna
vegan95114153vegan_
vegans103910853vegans
waging114318383waging
wagon94312953wagon_
wagons103911213wagons
wakanda1544013wakanda
wangan10311223wangan_
wangans1149503wangans
wigan95114393wigan_
wigans104511703wigans
zananas16319563zananas
zenana15297983zenana

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 Limit1127163006.06018600.0
3Display Results3003000.1102727.3
 (SQL Overall)1786913006.31028318.7
 
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.