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

219 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
lacunas913817(None) 
lacuna8118121lacuna_
lacunae9116801lacunae
lacunal9136551lacunal
lacunar9136291lacunar
lacunars10114731lacunars
lacunes9159621lacunes
lagunas8156821lagunas
faunas94013632fa_unas
jacanas1638262jacanas
kahunas1473952kahunas
lacings105013652lacings
lacunary13114152lacunary
lacunate10128962lacunate
lacune8169672lacun_e
lacunose1083792lacunose
laguna7127222laguna_
lagunes8148522lagunes
laminas93615872laminas
latinas74416462latinas
lauans65113532la_uans
lauras63414332la_uras
lunas55025012l__unas
maculas113114022maculas
saunas63915432sa_unas
vicunas1285612vicunas
acinar8310483_acinar
acinus8311253_acinus
acnes75922623_ac_nes
acutes83917723_acutes
ajugas1435263_ajugas
anas46649863_a__nas
annas55824883_a_nnas
aquas142412613_aqu_as
arenas65021993_arenas
asanas6514113_asanas
aucubas1145173aucubas
aunts55227633_a_unts
auras55932563_a_uras
bacons104917583bacon_s
bacula103112673bacula_
bananas93312223bananas
bunas75126573__bunas
cabanas112413033cabanas
cacas95627983cac__as
cannas84518403ca_nnas
canulas9312853canulas
carinas93622403carinas
catenas9313113catenas
clachans1546413clachans
cunts76125123__cunts
dachas124113253dac_has
daturas838773daturas
daunts75014083da_unts
dracenas1145793dracenas
encinas938723encinas
facias113415803fac_ias
facings134511263facings
facula112912233facula_
faculae123210353faculae
facular122810443facular
faenas94412763fa_enas
farinas103215233farinas
fauna84816513fa_una_
faunae95210373fa_unae
faunal94711593fa_unal
fauns84516753fa_un_s
flacons1238053flacon_s
flaunts1056133fla_unts
flautas1036153fla_utas
galenas83310343galenas
haunts95614393ha_unts
jacana1537933jacana_
jarinas143712183jarinas
jaunts137511883ja_unts
kachinas1736343kachinas
kahuna1394103kahuna_
kanas95326913ka__nas
katcinas1434513katcinas
korunas1135443korunas
lacers85225253lac_ers
laces76141763lac__es
laches116528343lac_hes
laciness102112553laciness
lacing94626233lacin_g
lackers134120543lackers
lackeys16458263lackeys
lacks116129203lac__ks
laconic1139883laconic
laconism1248043laconism
lacquers19125033lacquers
lacqueys22132693lacqueys
lacs66942483lac___s
lactam10310943lac_tam
lactams1136953lactams
lactase937953lac_tase
lacteal966813lacteal
lacteals1095663lacteals
lactean956473lactean
lactones10311233lactones
lacunaria1143793lacunaria
ladens74516233laden_s
ladings93814133ladings
ladinos8389963ladinos
lagans75717783lagan_s
lagends947273lagends
lagune7158633lagun_e
lakings124713513lakings
lallans74113533lallans
lamas75532793la__mas
lambdas1246243lambdas
laments94314853laments
lamias85020613la_mias
lamina84920443lamina_
laminae93512973laminae
laminal94113633laminal
laminals10339303laminals
laminar93810283laminar
lampas106615953la_mpas
lanai5319573la__nai
lanais6316793la__nais
lands65426903la__nds
lanes54946793la__nes
lantanas838263lantanas
lanugos834453lanugos
lapins84520683lapin_s
larums83610533laru_ms
larvas9310233la_rvas
lasagnas943673lasagnas
latens64620213laten_s
latents75214313latents
latina65621143latina_
latinos73613803latinos
latrias71913213latrias
lauan55216793la_u_an
lauds65618483la_u_ds
laughs10489023la_ughs
launce8469183la_unce
launces9329003la_unces
launch11368063la_unch
laura54116203la_ura_
laurae64011663la_urae
lavas85422223la__vas
lawines103313563lawines
lawings113611473lawings
lawns85215423la_wn_s
layins93817653layin_s
layups1133993layu_ps
lazulis1634903lazulis
lehuas935943lehu_as
lianas63713383l_ianas
ligulas8329173ligulas
lochans1248833lochans
locular938953locular
locules92812603locules
loculus9296973loculus
locums10478303locu_ms
locus74819993locu__s
locusts9277933locusts
loumas84812333l_oumas
lumas75622913l__umas
luna46229853l__una_
lunar57017313l__unar
lunars65012813l__unars
lunes55337773l__unes
lungs65223883l__ungs
lunks94822453l__unks
lunts55826903l__unts
lychnis1544383lychnis
lycras11287253lyc_ras
macons104017243macon_s
macula103013673macula_
maculae113412863maculae
macular113011943macular
macules114015133macules
macumbas1653013macumbas
mananas93414733mananas
manas76240433ma__nas
mannas85019803ma_nnas
marinas93519383marinas
maunds9519653ma_unds
mazumas2034623mazumas
mizunas1843693mizunas
nachas114914193nac_has
naganas847983naganas
nanas55928633na__nas
pacas96029403pac__as
pachas135017143pac_has
paruras9310533paruras
patinas96318523patinas
placentas1364823placentas
platinas103610313platinas
punas74826753__punas
racings105015133racings
racons84319343racon_s
radulas839583radulas
ramonas9311093ramonas
ranulas7311773ranulas
salinas73116093salinas
sarcinas1039273sarcinas
sauna54117553sa_una_
scenas84114703_scenas
scubas103710223_scubas
tabuns8489223tabun_s
talukas11316213talukas
taunts65715663ta_unts
tunas54224123__tunas
vaccinas1544973vaccinas
vacua10510463vacu_a_
vacuous1237023vacuous
vacuums1443403vacuums
vaginas11298813vaginas
valutas1036533valutas
varnas94212823va_rnas
vaunts95212623va_unts
vicugnas1442043vicugnas
vicuna11115903vicuna_
yamuns11336513yamun_s
zananas16319563zananas

Search took 10 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.420425454.8
2DLD Change Limit1340272198.89315071.1
3Display Results2192190.1561403.8
 (SQL Overall)1786912199.46918871.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.