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

346 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
faecal1135981(None) 
caecal103713731caecal
faucal11339961faucal
fecal105119211f_ecal
aecial84817312_aecial
caeca93915132caeca_
cecal94619112_cecal
daedal849082daedal
decal85523232_decal
facial113615632facial
faeces114713122faeces
faena85014202faena_
faenas94412762faenas
fallal93612692fallal
farfal123410192farfal
fascial1258302fascial
fatal84819372fa_tal
faucals12326562faucals
faucial1257322faucial
faunal94711592faunal
feal713940422f_e_al
fecial114714622f_ecial
feral85424652f_eral
fetal85623372f_etal
fiscal1139332fiscal
focal104917672f_ocal
foetal9311882foetal
haemal113811652haemal
jacal14313702ja_cal
laical8312322laical
pascal10812372pascal
rascal8511122rascal
thecal113310312thecal
aal39058673_a__al
acetal84314903acetal
acyl95314293_a_cyl
aecia73819283_aecia
aerial64625713_aerial
algal66518223_algal
anal48037523_a_nal
annal56520763_annal
apical10913903apical
appal95315223_appal
areal55928743_areal
areca75618633areca_
arecas84817453arecas
argal65023403_argal
artal55525483_artal
arval86017023_arval
aural54428963_aural
axal116520493_a_xal
axial124515193_axial
baal67033113ba__al
bacca111012183bacca_
baccae12119703baccae
banal75925993ba_nal
barbal104016673barbal
barca91319443barca_
barcas101016613barcas
basal75722283ba_sal
becalm1239203_becalm
becap114315053_becap
buccal1248243buccal
cabal95222153ca_bal
caca85528083ca_ca_
cacao95420003ca_cao
cacas95627983ca_cas
caecally1547703caecally
caecum1238183caecum
caesar8410943caesar
calcar10312753calcar
cameral11311283cameral
canal75428043ca_nal
cancan10314103cancan
cancel105316683cancel
cantal84122033cantal
caracal11312513caracal
carcel105018673carcel
carnal83919223carnal
carpal103716263carpal
casual81112873casual
catcall1139153catcall
caudal91611483caudal
causal81413203causal
ceca84820783_ceca_
cercal10314123cercal
chaetal1238283chaetal
coaeval1245183coaeval
coccal9310223coccal
coeval1138893coeval
credal9311673credal
deal56347413_de_al
decaf114919443_decaf
decals93717713_decals
decay114718483_decay
dedal75719023_dedal
ducal84816423_ducal
egal55119433__egal
epical10413393epical
facade1238803fa_cade
face96140123fa_c_e
faceable15108493faceable
faced117727653fa_ced
facer105525053fa_cer
facers115519443facers
faces106439433fa_ces
facet106038523fa_cet
facete115014833facete
facets116316653facets
faceup1334893faceup
facia103218463fa_cia
faciae112913413faciae
facials123310743facials
facias113415803facias
facile112514883fa_cile
fact97142543fa_c_t
facts107021893fa_cts
factual1246723factual
facula112912233fa_cula
faerie93514683faerie
faery116015483fae_ry
fail74840243fa__il
falbala1235873falbala
falcate12311623falcate
falces115216003falces
falcon11310293falcon
falderal12104803falderal
fall75535313fa__ll
fallals103310193fallals
fancily1538253fancily
fancy134615483fanc_y
fanega1055783fanega_
fanegas1145713fanegas
fanga96119633fanga_
fangas105017203fangas
fantail10310233fantail
farad95720683fa_rad
farce104925323farc_e
farced125216533farced
farcer115016083farcer
farces115223323farces
farci105919313farc_i
farcical1546953farcical
farcie114816473farcie
farcy135217093farc_y
fardel104712593fardel
farfals13268503farfals
farfel124310433farfel
farl76338553fa__rl
fasces114914543fasces
fascia1148703fascia
fasciae1247523fasciae
fascias1258413fascias
fateful1397513fateful
fatwa1168063fatwa_
fatwas1249053fatwas
fauces114916153fauces
faucet115816553faucet
fauna84816513fauna_
faunae95210373faunae
faunas94013633faunas
fava106820263fa_va_
favas115618593fa_vas
favela1237033favela_
favelas1337023favelas
favella1336173favella
fear75337793f_e_ar
feat76458223f_e_at
feces105625363f_eces
fecials123510333f_ecials
feck134923433f_ec_k
feckly18335963f_eckly
fecks145417853f_ecks
fecula113310053f_ecula
federal1148533federal
feel75233843f_e_el
fell76833073f_e_ll
fella84918653f_ella
female11310553f_emale
ferals94216643f_erals
ferial94621253ferial
festal94213563festal
feta76528903f_eta_
fetas85624403f_etas
fetial95716193fetial
feuar8310243f_euar
feudal1037683feudal
filial93013253filial
final83922033f_inal
finca104714503finca_
fincas113512073fincas
finial92814183finial
finical1239703finical
fiscals1238003fiscals
flatcap1463653flatcap
flatcar1274613flatcar
flea75628493fle_a_
fleam106017283fle_am
fleas86423663fle_as
fleche14299303fleche
fleck148213593flec_k
flecks154310803flecks
flecky18387653flecky
floral94313813floral
foal76630923f__oal
foeman11311233foeman
fontal9313143fontal
formal113215213formal
foveal1237703foveal
fracas11311993fracas
fractal1237623fractal
fraena938063fraena_
freak125115243fre_ak
freckle16106643freckle
freckly19124593freckly
frena85915273frena_
frugal1036393frugal
fuel76824733fue__l
fugal95613033f_ugal
funeral1037623funeral
fungal10388733fungal
gametal1037603gametal
gavial10310083gavial
gayal9312713ga_yal
hadal95518123ha_dal
halal85623593ha_lal
hallal94415563hallal
hamal104623123ha_mal
hammal134512073hammal
hartal9415483hartal
heal75645693_he_al
hemal104419803_hemal
hiemal11339513hiemal
hyetal1236543hyetal
icecap1245223icecap
ideal65716393ide_al
ileal56118083ile_al
ipecac1264623ipecac
jacals1539873ja_cals
jackal1937613jackal
labial84714343labial
larval948513larval
lascar868573lascar
lateral7313573lateral
leal46043273_le_al
legal65715943_legal
lienal63912793lienal
local74820273_local
macaw12311763ma_caw
madcap1336333madcap
maenad939413maenad
magical1239783magical
mammal95112763mammal
manual8313463manual
marcel103714853marcel
meal65643173_me_al
meatal84114733meatal
medal86221333_medal
mescal104113493mescal
metal75427383_metal
mezcal19367853mezcal
narial6317963narial
narwal938953narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
paca85132243pa_ca_
pacas96029403pa_cas
paean77222723pae_an
paella8410923paella
paesan85114093paesan
paleal84716673paleal
palpal104112053palpal
papal95820673pa_pal
parcel103915473parcel
parral85517543parral
pascals11610013pascals
paschal14157243paschal
pausal81511963pausal
peal68648103_pe_al
pecan91919033_pecan
pedal86022503_pedal
penal75228373_penal
petal76526893_petal
pical95524373_pical
plexal1536843plexal
plical10411683plical
quezal2435143quezal
racial83419243racial
radial74020393radial
radical103312793radical
ramal74622253ra_mal
rascals959663rascals
ratal55025113ra_tal
real45750293_re_al
recall83815733_recall
recap95718023_recap
recoal84117983_recoal
rectal84418143_rectal
regal65023793_regal
renal55929513_renal
sabal75422483sa_bal
sacral83414413sacral
salal55425703sa_lal
sambal105215183sambal
sandal73317283sandal
seal45654373_se_al
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
sheal84927703she_al
special11310303special
steal56125473ste_al
sulcal8311283sulcal
tael46030713tae__l
tamal73522633ta_mal
tapetal938273tapetal
tarnal63716513tarnal
tarsal63315283tarsal
teal45546503_te_al
tectal83713253_tectal
tepal76319583_tepal
theca103311453theca_
thecae11299653thecae
thenal92712433thenal
tical76021493_tical
tincal83913373tincal
toecap1037323toecap
ureal56722683ure_al
uveal84411073uve_al
vagal94613633va_gal
valval12398863valval
vandal103713833vandal
vasal85516293va_sal
vassal979243vassal
vatical1239983vatical
veal76936813_ve_al
venal85523213_venal
vocal104715643_vocal
wadmal1237293wadmal
waeful1238123waeful
weal75838683_we_al
wheal115716183whe_al
zeal135530333_ze_al
zoeal144813783zoe_al

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.500357382.0
2DLD Change Limit1127163466.05018630.7
3Display Results3463460.1103145.5
 (SQL Overall)1786913466.66026830.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.