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

241 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
fecula11331005(None) 
facula112912231facula
feculae12339201feculae
ferula93011171ferula
bacula103112672bacula
cedula977642cedula
faculae123210352faculae
facular122810442facular
fecal105119212fecal_
fecial114714622fecial
feckly18335962feckly
fecund1235432fecund
fella84918652fe_lla
ferulae10309602ferulae
ferulas103110752ferulas
ferule93413202ferule
fibula11258052fibula
frenula1045622frenula
furcula1245792furcula
macula103013672macula
nebula857332nebula
oscula837292oscula
peculia1147132peculia
secular92211532secular
specula11187412specula
acicula11228133acicula
aecia73819283aec_ia
aecial84817313aecial
alula5317093_alula
aucuba1045493aucuba
becalm1239203becalm
begulf1238903begulf
beluga936233beluga
canula8312963canula
ceca84820783cec__a
cecal94619113cecal_
cecum11611843cecu_m
cedulas1058503cedulas
cella75420313ce_lla
cesura838763cesura
cicala10310053cicala
cola66541393__cola
copula102812043copula
cull65929643__cull
culm85822383__culm
culpa93610963__culpa
cult66541153__cult
cupula10328433cupula
decal85523233decal_
decals93717713decals
decile94619213decile
deckle1312012453deckle
declaw1266703dec_law
decuman1236573decuman
decuple1285363decuple
decury1277963decury
doula65717773_doula
eclat7523603_ec_lat
ecu56828233_ecu__
ecus65421463_ecu_s
equal1449823_equal
exult122814123_exult
fabular12288693fabular
facia103218463fac_ia
facial113615633facial
facile112514883facile
factual1246723factual
faculty1535573faculty
faecal11359813faecal_
famuli1136763famuli
faucal11339963faucal
fauld95214493f_auld
fault85428313f_ault
fauna84816513f_auna
favela1237033favela
feal713940423fe_al_
featly123711753featly
feces105625363fec_es
fecials123510333fecials
feck134923433fec__k
fecks145417853fec_ks
feculent1346953feculent
fedora1038593fedora
feeble1138253feeble
feebly1436653feebly
feel75233843fe_el_
feels85223043fe_els
feijoa1642223feijoa
fell76833073fe__ll
fellah124910773fe_llah
fellas95116963fe_llas
fells85327383fe_lls
felly114922803fe_lly
felt75146933fe__lt
felucca1442123felucca
female11310553female
femora1149583femora
femur1038683femu_r
femurs1136713femurs
feral85424653feral_
ferals94216643ferals
feria85922713fe_ria
ferial94621253ferial
ferly115517353fe_rly
ferrule1035863ferrule
feruled11318413feruled
ferules103112723ferules
fescue1137493fescu_e
fescues1236783fescues
festal94213563festal
feta76528903fe__ta
fetal85623373fetal_
fetial95716193fetial
fettle93713123fettle
fetus85816543fetu_s
feu67843663fe_u__
feuar8310243fe_uar
feud86523023fe_u_d
feudal1037683fe_udal
feuds95914883fe_uds
feued94715663fe_ued
feus75830753fe_u_s
feyly14429513fe_yly
fibulae12237013fibulae
fibular12267973fibular
fibulas12228563fibulas
fickle153912973fickle
fickly18318533fickly
ficus105015493ficu_s
fila74729133f__ila
fistula1045503fistula
flauta937823flauta
focal104917673focal_
focus105815883focu_s
formula1246293formula
foul77027583f_oul_
fouls87221433f_ouls
freckle16106643freckle
freckly19124593freckly
frenular1144633frenular
fucus105515893fucu_s
full75229153f__ull
fumuli1135263fumuli
furculae1345063furculae
furcular1345703furcular
fusuma1134503fusuma
genua64614153genu_a
heckle153112093heckle
hula74923753__hula
incult82414773incult
inocula947263inocula
jejuna1243243jejuna
jocular1637303jocular
jugula1434983jugula
keckle11359423keckle
lacuna8118123lacuna
lehua837953lehu_a
ligula7359673ligula
locular938953locular
locule83412033locule
loculi8288253loculi
lunula636173lunula
maculae113412863maculae
macular113011943macular
maculas113114023maculas
macule104115273macule
mecca1139933mec_ca
medulla1044713medulla
medusa936293medusa
mezuza1643533mezuza
morula8710473morula
nebulae955493nebulae
nebular956483nebular
nebulas957583nebulas
nebule848753nebule
nebuly1135793nebuly
neurula744373neurula
occult1038433occult
ocular8610133_ocular
oculi72010793_oculi
opercula1244993opercula
oscular937933oscular
oscule838193oscule
papula103011113papula
peculate122414663peculate
peculiar1245453peculiar
penult8314653penult
pepla9312863pe_pla
picul95015363picul_
piculs103511753piculs
pula65129373__pula
radula749313radula
ranula6311813ranula
recall83815723recall
reclad9311873rec_lad
recoal84117973recoal
recta74220263rec_ta
rectal84418133rectal
recur74116843recu_r
recurs83315803recurs
recusal968673recusal
recuse85519163recuse
recut74729243recu_t
recuts83817373recuts
regular838423regular
reguli738143reguli
remuda936823remuda
result6318223result
reticula1047413reticula
scuba94211593_scuba
sculk115112463_sculk
scull75315763_scull
sculp95314843_sculp
scuta75815753_scuta
seculars10219393seculars
secund937103secund
secure8513533secure
sequela1663993sequela
sexual1338413sexual
specular12217613specular
spicula11259293spicula
tecta74215523tec_ta
tectal83713253tectal
tegua6109563tegu_a
tegular836603tegular
tela45532973te__la
tenacula1044493tenacula
tequila1644583tequila
tesla55612603te_sla
torula6610393torula
ungula737603ungula
uvula845153_uvula
vacua10510463vacu_a
vascula1245853vascula
vela75725543ve__la
venular1037683venular
venule94411763venule
vesicula1345223vesicula
vicuna11115903vicuna
vincula1246393vincula
zonula1537223zonula

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 Limit1127162416.40617595.4
3Display Results2412410.1261912.7
 (SQL Overall)1786912416.67226782.2
 
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.