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

121 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
lacunae911680(None) 
lacuna8118121lacuna_
lacunal9136551lacunal
lacunar9136291lacunar
lacunas9138171lacunas
lacunate10128961lacunate
lacune8169671lacun_e
faculae123210352faculae
faunae95210372fa_unae
lacunars10114732lacunars
lacunary13114152lacunary
lacunes9159622lacunes
lacunose1083792lacunose
laguna7127222laguna_
lagunas8156822lagunas
lagune7158632lagun_e
laminae93512972laminae
launce8469182la_unce
laurae64011662la_urae
maculae113412862maculae
acinar8310483_acinar
acne66625873_ac_n_e
acuate8315633_acuate
acute74720363_acu_te
aliunde835003aliunde
alulae6312743_alulae
alumnae955403alumnae
aquae142212713_aqu_ae
aurae54128113_a_urae
baccae12119703bac_cae
bacula103112673bacula_
canulae9311183canulae
carinae94318583carinae
catenae9311373catenae
faciae112913413fac_iae
facula112912233facula_
facular122810443facular
fauna84816513fa_una_
faunal94711593fa_unal
faunas94013633fa_unas
feculae12339203feculae
jacana1537933jacana_
jacanas1638263jacanas
jaculate172311783jaculate
jaunce15367433ja_unce
kahuna1394103kahuna_
kahunas1473953kahunas
lace66848473lac___e
lacerate102214703lacerate
lacing94626233lacin_g
lacings105013653lacings
laciniate1156843laciniate
laconic1139883laconic
lactam10310943lac_tam
lactase937953lactase
lactate9312693lactate
lacteal966813lacteal
lactean956473lactean
lactone9311393lactone
lactose969473lactose
lacunaria1143793lacunaria
lagunes8148523lagunes
lamiae84817453la_miae
lamina84920443lamina_
laminal94113633laminal
laminar93810283laminar
laminas93615873laminas
laminate103014633laminate
lanai5319573la__nai
lanate6421263la__nate
lance75126723la__nce
lancinate1147803lancinate
lane45153333la__n_e
larine63927043larin_e
larvae938843la_rvae
latina65621143latina_
latinas74416463latinas
lauan55216793la_u_an
lauans65113533la_uans
launces9329003la_unces
launch11368063la_unch
launder8309143la_under
laura54116203la_ura_
lauras63414333la_uras
lawine93316463lawin_e
licence11119363licence
license9148423license
licente91210893licente
ligulae8308753ligulae
locular938953locular
loculate101011403loculate
locule83412033locu_le
locustae10274713locustae
lounge75211213l_ounge
lucence11148003lucence
luna46229853l__una_
lunar57017313l__unar
lunas55025013l__unas
lunate6316043l__unate
lune47140493l__un_e
lunge65323803l__unge
lunulae735613lunulae
macula103013673macula_
macular113011943macular
maculas113114023maculas
maculate122815623maculate
macule104115273macu_le
papulae11249353papulae
patinae95414403patinae
placentae1364353placentae
planulae1044793planulae
radulae837963radulae
sarcinae1047193sarcinae
sauna54117553sa_una_
saunaed836703sa_unaed
saunas63915433sa_unas
vacua10510463vacu_a_
vacuole1245373vacuole
vaginae11377683vaginae
vicuna11115903vicuna_
vicunas1285613vicunas

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271216.48320673.6
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.66926794.3
 
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.