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

173 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
faculae12321035(None) 
facula112912231facula_
facular122810441facular
feculae12339201feculae
maculae113412861maculae
alulae6312742_alulae
bacula103112672bacula_
canulae9311182canulae
fabular12288692fabular
fabulate1339202fabulate
faciae112913412fac_iae
facile112514882facil_e
faculty1535572faculty
faunae95210372fa_unae
fecula113310052fecula_
ferulae10309602ferulae
fibulae12237012fibulae
furculae1345062furculae
jaculate172311782jaculate
lacunae9116802lacunae
macula103013672macula_
macular113011942macular
maculas113114022maculas
maculate122815622maculate
macule104115272macul_e
papulae11249352papulae
radulae837962radulae
aciculae12267703aciculae
acuate8315633_acuate
aculeate1039923_aculeate
aculei839793_aculei
acute74720363_acu_te
acylate12310533_acylate
adulate8313233_adulate
alae45643753_a__lae
alula5317093_alula_
alular6311353_alular
aquae142212713_aqu_ae
aurae54128113_a_urae
avulse935843_avulse
bacalao1146613bacalao
baccae12119703bac_cae
baculine1238983baculine
baculum1345703baculum
bascule1136573bascul_e
cackle143416923cackl_e
calculate1389873calculate
cannulae1046493cannulae
canula8312963canula_
canular9310323canular
canulas9312853canulas
canulate10314553canulate
copulae112810613copulae
culpae10389263__culpae
cupulae11347853cupulae
ejaculate18187163ejaculate
fable105824753fa_bl_e
fabulated1546323fabulated
fabulates1447733fabulates
facade1238803fac_ade
face96140123fac___e
faceplate1645223faceplate
facete115014833fac_ete
facetiae1346213facetiae
facia103218463fac_ia_
facial113615633fac_ial
facials123310743facials
facias113415803fac_ias
factual1246723factual
facture12108923facture
faculties1455143faculties
faille93414743fa_ille
failure1035753failure
fallal93612693fa_llal
false84818123fa__lse
famuli1136763famul_i
famulus1235043famulus
farle86929243fa_rl_e
fasciae1247523fasciae
faucal11339963fa_ucal
faucals12326563faucals
faucial1257323faucial
fauld95214493fa_ul_d
faulds10438963fa_ulds
fault85428313fa_ul_t
faulted11227723fa_ulted
faults94513553fa_ults
faulty12429363fa_ulty
fauna84816513fa_una_
faunal94711593fa_unal
faunas94013633fa_unas
fauve114712073fa_u_ve
favela1237033favela_
favelas1337023favelas
ferula93011173ferula_
ferulas103110753ferulas
ferule93413203ferul_e
fibula11258053fibula_
fibular12267973fibular
fibulas12228563fibulas
fickle153912973fickl_e
fistulae1144533fistulae
formulae1345983formulae
furcula1245793furcula_
furcular1345703furcular
hackle154916813hackl_e
hamular1236973hamular
hamulate1359013hamulate
haulage1136913ha_ulage
jaculated19289053jaculated
jaculates182810363jaculates
jocular1637303jocular
lacuna8118123lacuna_
lacunal9136553lacunal
lacunar9136293lacunar
lacunas9138173lacunas
lacunate10128963lacunate
lacune8169673lacu_ne
laurae64011663la_urae
ligulae8308753ligulae
locular938953locular
loculate101011403loculate
locule83412033locul_e
lunulae735613lunulae
mackle143716433mackl_e
macle96127003mac_l_e
maculated142411503maculated
maculates132013723maculates
maculed123510053maculed
macules114015133macules
morulae958963morulae
nacelle938153nacelle
nebulae955493nebulae
ocular8610133_ocular
oracular1047533oracular
oscula837293oscula_
oscular937933oscular
osculate101010613osculate
oscule838193oscul_e
pabular11259473pabular
papula103011113papula_
papular11299763papular
papule102212133papul_e
peculate122414673peculate
piacular1246573piacular
planulae1044793planulae
rackle123917293rackl_e
radula749313radula_
radular837833radular
radulas839583radulas
ranula6311813ranula_
ranular739433ranular
ranulas7311773ranulas
saccular1246893saccular
sacculate1349023sacculate
saccule1136743saccul_e
scapulae1255433scapulae
secular92211533secular
spiculae12218603spiculae
tabular9279763tabular
tabulate10310893tabulate
tackle123815733tackl_e
torulae758553torulae
ungulae837313ungulae
uvulae945323_uvulae
vacua10510463vacu_a_
vacuolar1353483vacuolar
vacuolate1445223vacuolate
vacuole1245373vacuole
valvulae1442723valvulae
vascula1245853vascula_
vascular1346293vascular
zonulae1645963zonulae

Search took 9 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.403443402.0
2DLD Change Limit1340271737.95616846.0
3Display Results1731730.0762276.3
 (SQL Overall)1786911738.43521184.5
 
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.