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

294 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
lacuna811812(None) 
lacunae9116801lacunae
lacunal9136551lacunal
lacunar9136291lacunar
lacunas9138171lacunas
lacune8169671lacune
laguna7127221laguna
bacula103112672bacula
facula112912232facula
fauna84816512fa_una
jacana1537932jacana
kahuna1394102kahuna
lacing94626232lacing
lacunars10114732lacunars
lacunary13114152lacunary
lacunate10128962lacunate
lacunes9159622lacunes
lagunas8156822lagunas
lagune7158632lagune
lamina84920442lamina
latina65621142latina
lauan55216792la_uan
laura54116202la_ura
luna46229852l__una
macula103013672macula
sauna54117552sa_una
vacua10510462vacu_a
vicuna11115902vicuna
aceta74017353_aceta
acinar8310483_acinar
acing87429153_acing
acini75718983_acini
acne66625873_ac_ne
acta69524803_ac_ta
acute74720363_acute
adunc837433_adunc
ajuga1335883_ajuga
alula5317093_alula
alumna857343alumna
ana39559823_a__na
anna45529013_a_nna
aqua132813963_aqu_a
arcana8912583arcana
arena55323813_arena
asana5315483_asana
aucuba1045493aucuba
aunt46553653_a_unt
aura45836253_a_ura
bacca111012183bac_ca
bacon95620593bacon_
bacons104917583bacons
banana83213413banana
buna64730723__buna
cabana103913563cabana
caca85528083cac__a
canna75919333ca_nna
canula8312963canula
carina84325323carina
catena8312483catena
clachan1437183clachan
cunt66243673__cunt
dacha114812573dac_ha
datura738023datura
daunt65929083da_unt
dracena1034923dracena
encina8310443encina
facia103218463fac_ia
facing125321573facing
faculae123210353faculae
facular122810443facular
faena85014203fa_ena
farina94618233farina
faun76226623fa_un_
faunae95210373fa_unae
faunal94711593fa_unal
faunas94013633fa_unas
fauns84516753fa_uns
fecula113310053fecula
fecund1235433fecund
flacon1138633flacon_
flacons1238053flacons
flaunt9712913fla_unt
flauta937823fla_uta
galena74911093galena
gaun56427713ga_un_
gaunt65430403ga_unt
haunt85229133ha_unt
iracund1042633iracund
jacanas1638263jacanas
jarina134014063jarina
jaunt125025273ja_unt
jejuna1243243jejuna
jocund1633623jocund
kachina1637663kachina
kahunas1473953kahunas
kana85928523ka__na
katcina1345153katcina
koruna1035483koruna
kuna85120703__kuna
labara83712893labara
labia75219013la_bia
labra75415463la_bra
lac510155823lac___
lace66848473lac__e
laced87132643lac_ed
lacer75833753lac_er
lacers85225253lacers
laces76141763lac_es
lacey105820913lac_ey
laches116528343laches
lacier84020093lacier
lacily11612763lacily
lacings105013653lacings
lack105837683lac__k
lacked135324653lacked
lacker125325623lacker
lackey154813353lackey
lacking143821543lacking
lacks116129203lac_ks
laconic1139883laconic
lacquer18135153lacquer
lacquey21143803lacquey
lacs66942483lac__s
lactam10310943lactam
lacteal966813lacteal
lactean956473lactean
lactic10713493lactic
lactone9311393lactone
lacunaria1143793lacunaria
lacunose1083793lacunose
lacy95829633lac__y
laden65022193laden_
ladens74516233ladens
lading84227123lading
ladino73615123ladino
lagan66520343lagan_
lagans75717783lagans
lagend838743lagend
lagunes8148523lagunes
lain46146283la_in_
laking115027043laking
lallan63414173lallan
lama66635293la__ma
lambda1146113lambda
lament85024943lament
lamia75324323la_mia
laminae93512973laminae
laminal94113633laminal
laminar93810283laminar
laminas93615873laminas
laming94528363laming
lanai5319573la__nai
lancing103314123lancing
land56337303la__nd
lane45153323la__ne
lang56637373la__ng
lank84734443la__nk
lantana739603lantana
lanugo735573lanugo
lapin75222923lapin_
lapins84520683lapins
larceny1234853larceny
larine63927043larine
larum74317973laru_m
larums83610533larums
larva8312483la_rva
larynx1632853larynx
lasagna843543lasagna
lasing74727983lasing
laten54328343laten_
latens64620213latens
latent64124303latent
latinas74416463latinas
latino64120473latino
latria62313593latria
latu47934183latu__
lauans65113533lauans
laud56527723la_u_d
lauds65618483la_uds
laugh94414373la_ugh
launce8469183la_unce
launch11368063la_unch
laurae64011663la_urae
lauras63414333la_uras
lava76725423la__va
laving104623573laving
lawine93316463lawine
lawing104625283lawing
lawman11289053lawman
lawn75925633la_wn_
lawns85215423la_wns
lawny115912013la_wny
layin84720333layin_
laying104525703laying
layins93817653layins
layman113511303layman
layup1037723layu_p
layups1133993layups
lazing164821473lazing
lazuli1535363lazuli
lehua837953lehu_a
liana53915893l_iana
ligula7359673ligula
likuta1034213likuta
limina83514503limina
loca65527683loc__a
lochan1139093lochan
lochia1158313lochia
locular938953locular
locule83412033locule
loculi8288253loculi
locum94812173locu_m
locums10478303locums
locus74819993locu_s
locust85312343locust
locusta9326533locusta
louma76213633l_ouma
lucent8313823lucent
luma65527523l__uma
lumina84613543lumina
lunar57017313l__unar
lunas55025013l__unas
lune47140493l__une
lung55732493l__ung
lunk86030723l__unk
lunt46148843l__unt
lunula636173lunula
luny77324133l__uny
lycea10418943lyc_ea
lycra10317973lyc_ra
macing114221553macing
macon94519953macon_
macons104017243macons
maculae113412863maculae
macular113011943macular
maculas113114023maculas
macule104115273macule
macumba1573043macumba
makuta1236393makuta
mana65341943ma__na
manana84816073manana
manna75522533ma_nna
marina84623413marina
maun65727203ma_un_
maund85515443ma_und
mazuma1935603mazuma
mizuna1734303mizuna
nagana748943nagana
nana46632893na__na
oscula837293oscula
paca85132243pac__a
pacha126518063pac_ha
pacing114522753pacing
papula103011113papula
parura8310583parura
patina86022193patina
placenta1275723placenta
placing123815283placing
planula935773planula
platina94413643platina
puna65331653__puna
racing95030533racing
racon75422143racon_
racons84319343racons
radula749313radula
ramona8412413ramona
ranula6311813ranula
sacra74516993sac_ra
salina64221123salina
sarcina9310733sarcina
saunas63915433sa_unas
scena74815783_scena
scuba94211593_scuba
scuta75815753_scuta
secund937103secund
tabun75914373tabun_
tabuns8489223tabuns
taluka10426773taluka
taunt55532283ta_unt
tuna45127843__tuna
vacant11415133vacant
vaccina1435303vaccina
vacuum1334833vacuum
vagina102710933vagina
valuta938743valuta
varna84516173va_rna
vascula1245853vascula
vaunt85925313va_unt
vicugna1342083vicugna
vicunas1285613vicunas
yakuza2261873yakuza
yamun10419273yamun_
yamuns11336513yamuns
zanana153810363zanana

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 Limit1127162945.82619347.1
3Display Results2942940.0933161.3
 (SQL Overall)1786912946.05929491.8
 
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.