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

141 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
feculae1233920(None) 
faculae123210351faculae
fecula113310051fecula_
ferulae10309601ferulae
facula112912232facula_
facular122810442facular
ferula93011172ferula_
ferulas103110752ferulas
ferule93413202ferul_e
fibulae12237012fibulae
furculae1345062furculae
maculae113412862maculae
nebulae955492nebulae
peculate122414662peculate
secular92211532secular
aciculae12267703aciculae
alulae6312743_alulae
bacula103112673bacula_
becurse1136183becurse
canulae9311183canulae
cedula977643cedula_
cedulas1058503cedulas
cellae84915933ce_llae
cesurae937703cesurae
copulae112810613copulae
culpae10389263__culpae
cupulae11347853cupulae
decile94619213decil_e
deckle1312012453deckl_e
declare10411223dec_lare
declaw1266703dec_law
decuman1236573decuman
decuple1285363decuple
decurve1335583decurve
eclat7523603_ec_lat
effulge1442473effulge
emulate9314123_emulate
euclase938933_euclase
evulse935213_evulse
fabular12288693fabular
fabulate1339203fabulate
faciae112913413fac_iae
facile112514883facil_e
faculty1535573faculty
faunae95210373f_aunae
fecal105119213fec__al
fecial114714623fec_ial
fecials123510333fecials
feckly18335963feckl_y
feculence1644823feculence
feculent1346953feculent
fecund1235433fecu_nd
fecundate1542993fecundate
feeble1138253feebl_e
fella84918653fe_lla_
fellah124910773fe_llah
fellas95116963fe_llas
fellate10313433fe_llate
felloe93513923fe_lloe
female11310553femal_e
feriae95618603fe_riae
ferlie92814053fe_rlie
ferrule1035863ferrul_e
feruled11318413feruled
ferules103112723ferules
fescue1137493fescu__e
fettle93713123fettl_e
feuar8310243fe_u_ar
feudal1037683fe_udal
fibula11258053fibula_
fibular12267973fibular
fibulas12228563fibulas
fickle153912973fickl_e
fistulae1144533fistulae
formulae1345983formulae
freckle16106643freckl_e
frenula1045623frenula_
frenular1144633frenular
furcula1245793furcula_
furcular1345703furcular
heckle153112093heckl_e
jaculate172311783jaculate
jocular1637303jocular
keckle11359423keckl_e
lacunae9116803lacunae
ligulae8308753ligulae
locular938953locular
loculate101011403loculate
locule83412033locul_e
lunulae735613lunulae
macula103013673macula_
macular113011943macular
maculas113114023maculas
maculate122815623maculate
macule104115273macul_e
medullae1143203medullae
medusae1044763medusae
morulae958963morulae
nebula857333nebula_
nebular956483nebular
nebulas957583nebulas
nebule848753nebul_e
necklace1643643necklace
neurulae843383neurulae
ocular8610133_ocular
oscula837293oscula_
oscular937933oscular
osculate101010613osculate
oscule838193oscul_e
papulae11249353papulae
peculated142310843peculated
peculates132112543peculates
peculia1147133peculia
peculiar1245453peculiar
radulae837963radulae
reclad9311873rec_lad
reclame11411063rec_lame
recluse95210773recluse
recurve1237403recurve
recusal968673recusal
recuse85519163recu_se
regular838423regular
regulate9313023regulate
repulse938193repulse
seclude1035233seclude
seculars10219393seculars
secure8513533secu_re
sequelae1753673sequelae
specula11187413specula_
specular12217613specular
speculate13239183speculate
spiculae12218603spiculae
tegular836603tegular
telae54323293te__lae
torulae758553torulae
ungulae837313ungulae
uvulae945323_uvulae
venular1037683venular
venule94411763venul_e
vesiculae1445203vesiculae
zonulae1645963zonulae

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271417.12618808.2
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.32524394.7
 
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.