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

264 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
jacana153793(None) 
jacanas1638261jacanas
arcana8912582arcana
asana5315482_asana
banana83213412banana
cabana103913562cabana
jacal14313702jaca_l
jacals1539872jacals
jacamar1844322jacamar
japan14411232japan_
japans1539822japans
jarina134014062jarina
jawan15710382jawan_
jawans1657842jawans
jicama1734872jicama
jnana12159042j_nana
lacuna8118122lacuna
manana84816072manana
nagana748942nagana
vacant11415132vacant
zanana153810362zanana
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
acacia10311353_acacia
acantha1254653_acantha
acapnia1145913_acapnia
acari75020283_acari
aceta74017353_aceta
acinar8310483_acinar
acing87429153_acing
acini75718983_acini
acne66625873_ac_ne
acta69524803_ac_ta
agama85815573_agama
alan46844083_alan_
aland65526413_aland
alane56135613_alane
alang66023513_alang
alans55636173_alans
alant55742293_alant
amarna839793_amarna
ana39559823___ana
anna45529013_a_nna
arcane81216743arcane
arena55323813_arena
asanas6514113_asanas
avant86224663_avant
azan136521783_azan_
azans146516883_azans
bacalao1146613bacalao
bacca111012183bac_ca
baccara1347143baccara
bacon95620593bacon_
bacons104917583bacons
bacula103112673bacula
balata8614673balata
bananas93312223bananas
bandana10179463bandana
bwana10310243_bwana
cabala103516913cabala
cabanas112413033cabanas
caca85528083__caca
cacao95420003caca_o
cacaos104616183cacaos
cacas95627983caca_s
calcanea1276273calcanea
can57760133__can_
canal75428043__canal
cancan10314103cancan_
cancans11311873cancans
cane66653113__cane
canna75919333ca_nna
cans65050843__cans
cant66362023__cant
carina84325323carina
casa65630863__casa
casaba1079263casaba
casava1157873casava
cascara1138313cascara
catena8312473catena
choana1138443choana
cicada1136413cicada
cicala10310053cicala
dacha114812573dac_ha
daman84821163daman_
damans94715983damans
damiana1046563damiana
decanal1038113decanal
decane93818873decane
decant93524223decant
dracaena1142203dracaena
dracena1034923dracena
encina8310443encina
facade1238803facade
facia103218463fac_ia
facing125321573facing
facula112912233facula
faena85014203fa_ena
farina94618233farina
fauna84816513fa_una
galanga936013galanga
galena74911093galena
gazania1746113gazania
grana65722093_grana
guarana886303guarana
halala94715093halala
hamada1239913hamada
hariana10310243hariana
hawala12368913hawala
hazan173813613hazan_
hazans183411653hazans
iguana735803iguana
incant82418503incant
jacales16310323jacales
jacamars1944003jacamars
jacaranda1952053jacaranda
jacinth1954603jacinth
jack175224863jac__k
jackal1937613jackal
jackals2036893jackals
jackass2034963jackass
jackdaw2442843jackdaw
jacked204817523jacked
jacker194417583jacker
jacket194720673jacket
jacking214515263jacking
jacks185219833jac_ks
jacky215412343jac_ky
jaconet16311483jaconet
jading154214023jading
jagra1338173ja_gra
jalap143612473jala_p
jalaps15299183jalaps
jane115031473j__ane
japing165013573japing
jarinas143712183jarinas
jaunt125025273ja_unt
java147316643j__ava
javas155915423java_s
jawing174414963jawing
jean116629283j_ean_
jeans126022113j_eans
jejuna1243243jejuna
jicamas1845043jicamas
jnanas13207303j_nanas
jocund1633623jocund
jurant134216553jurant
kabaka11348503kabaka
kabala124011553kabala
kabaya15387123kabaya
kachina1637663kachina
kahuna1394103kahuna
kamala12339963kamala
kana85928523__kana
kanaka9357523kanaka
katcina1345153katcina
labara83712893labara
lacing94626233lacing
lacunae9116803lacunae
lacunal9136553lacunal
lacunar9136293lacunar
lacunas9138173lacunas
lacune8169673lacune
lagan66520343lagan_
lagans75717783lagans
laguna7127223laguna
lamina84920443lamina
lantana739603lantana
lasagna843543lasagna
latina65621143latina
lauan55216793lauan_
lauans65113533lauans
liana53915893_liana
macaco1247853macaco
macadam1446853macadam
macaw12311763maca_w
macaws1337023macaws
macing114221553macing
macon94519953macon_
macons104017243macons
macula103013673macula
malanga1036663malanga
mana65341943__mana
mananas93414733mananas
manna75522533ma_nna
maraca10314153maraca
maranta9311693maranta
marina84623413marina
masala8311813masala
mascara1138023mascara
mayan105616903mayan_
naan47621933na_an_
naans55815253na_ans
naganas847983naganas
nana46632893__nana
natant6318733natant
organa789213organa
paca85132243pac__a
pacas96029403paca_s
pacha126518063pac_ha
pacing114522753pacing
paean77222723paean_
paeans85118263paeans
pagan86121163pagan_
pagans95717923pagans
paisana94010223paisana
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213343panama
papaya1337503papaya
parang93715513parang
pataca10311193pataca
patina86022193patina
pavan106518473pavan_
pavane114113443pavane
pavans115715593pavans
pecan91919033pecan_
pecans101515833pecans
picara10311903picara
pirana8713263pirana
purana8712933purana
qabala17399193qabala
racing95030533racing
racon75422143racon_
racons84319343racons
ramada9310183ramada
ramona8412413ramona
ratan53722663ratan_
ratans63819373ratans
ratany93411873ratany
recane83022873recane
recant83228683recant
ruana5312423_ruana
sacra74516993sac_ra
salina64221123salina
samara8313853samara
saran53730303saran_
sarans64224433sarans
sarcina9310733sarcina
sardana838643sardana
satang75711563satang
satara6315533satara
sauna54117553sa_una
savanna1043713savanna
savant9416043savant
scan65530453_scan_
scans74625103_scans
scant79735073_scant
scena74815783_scena
secant84023293secant
tarama8412723tarama
tartana73010193tartana
vacancy1744443vacancy
vacate11314553vacate
vaccina1435303vaccina
vacua10510463vac_ua
vagina102710933vagina
varna84516173va_rna
vicuna11115903vicuna
wakanda1544013wakanda
zananas16319563zananas
zenana15297983zenana

Search took 8 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 Limit1127162646.65616934.5
3Display Results2642640.0962750.0
 (SQL Overall)1786912646.89225927.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.