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

491 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
facial11361563(None) 
facia103218461facia_
faciae112913411faciae
facials123310741facials
facias113415801facias
fascial1258301fascial
faucial1257321faucial
fecial114714621fecial
racial83419241racial
aecial84817312aecial
axial124515192_axial
bifacial15105272bifacial
facially1637642facially
facies113921592facies
facile112514882facile
facing125321572facing
factual1246722factual
facula112912232facula
faecal11359812faecal
fail74840242fa_i_l
fallal93612692fallal
farcical1546952farcical
farfal123410182farfal
fascia1148702fascia_
fasciae1247522fasciae
fascias1258412fascias
fatal84819372fa_tal
faucal11339962faucal
faunal94711592faunal
fecal105119212fec_al
fecials123510332fecials
ferial94621252ferial
fetial95716192fetial
filial93013252filial
finial92814182finial
focal104917672foc_al
fractal1237622fractal
gavial10310082gavial
glacial1038142glacial
jacal14313702jac_al
jackal1937612jackal
labial84714342labial
laical8312322laical
narial6317952narial
nasial6413282nasial
rachial122012172rachial
radial74020392radial
sacral83414412sacral
social8813332social
spacial1138762spacial
uncial83715222uncial
aal39058673_a__al
abaxial1646183abaxial
acacia10311353acacia_
acacias11510403acacias
acetal84314903_acetal
achiral12109183_achiral
acid77533393_aci_d
acidly125211793_acidly
acids87121003_acids
acidy117214893_acidy
acinar8310483_acinar
acing87429153_acing
acini75718983_acini
acta69524803_acta_
actinal9312293_actinal
actual8311023_actual
acyl95314293_ac_yl
adagial946373adagial
adaxial1545323adaxial
aecia73819283aecia_
aerial64625713aerial
affinal1336443affinal
affixal2043763affixal
ail37171043_a_i_l
algal66518223_algal
alias55834603_alias
amia66836903_amia_
amias75831473_amias
anal48037523_a_nal
anil46437433_ani_l
animal85016253_animal
annal56520763_annal
apian75018333_apian
apical10913903_apical
appal95315223_appal
areal55928733_areal
argal65023393_argal
aria46245423_aria_
arias55438023_arias
ariel55228973_ariel
aril45843023_ari_l
artal55525473_artal
arval86017013_arval
asocial998653asocial
atrial65418943atrial
audial7312993audial
aural54428963_aural
avail8313883_avail
avian84616053_avian
axal116520493_a_xal
axil116424453_axi_l
baal67033113ba__al
bacca111012183bacca_
baccae12119703baccae
bacilli1146393bacilli
bacula103112673bacula
bail65042803ba_i_l
banal75925993ba_nal
banian8315383banian
barbal104016663barbal
basal75722283ba_sal
basil75122273basi_l
basinal9310033basinal
biaxial1645363biaxial
biracial12107973biracial
brachial15219303brachial
buccal1248243buccal
burial84117623burial
cabal95222153ca_bal
caca85528083cac_a_
cacao95420003cac_ao
cacas95627983cac_as
caecal103713733caecal
camail10314833camail
cambial134010763cambial
canal75428043ca_nal
cantal84122033cantal
capias10318353capias
capital112311523capital
carinal94318243carinal
carnal83919213carnal
carpal103716253carpal
casual81112863casual
caudal91611483caudal
causal81413203causal
caviar11310163caviar
cavil103816493cavi_l
cecal94619113cec_al
ciao64924183__ciao
coal66939253__coal
coaxial16157003coaxial
coccal9310223coccal
cranial92114683cranial
crucial1157893crucial
curial84019153curial
dacha114812573dacha_
dachas124113253dachas
dacite91115883dacite
dactyl1234983dactyl
daedal849083daedal
datival1135583datival
decal85523233dec_al
decimal1238083decimal
decrial10310323decrial
denial74720513denial
dial55935063__dial
ducal84816423duc_al
ductal938993ductal
encinal949243encinal
epical10413393epical
espial839543espial
fabliau1244903fabliau
facade1238803facade
face96140123fac__e
faceable15108493faceable
faced117727653fac_ed
facer105525053fac_er
facers115519443facers
faces106439433fac_es
facet106038523fac_et
facete115014833facete
facetiae1346213facetiae
facets116316653facets
faceup1334893faceup
faciend1334803faciend
facilely1644363facilely
facings134511263facings
fact97142543fac__t
factful1536373factful
faction122613333faction
factional1478763factional
factoidal1543333factoidal
factor11911453factor
factorial1447023factorial
facts107021893fac_ts
faculae123210353faculae
facular122810443facular
fading114821113fading
faena85014203faena_
faenas94412763faenas
fagin9216573fagi_n
fagins10513863fagins
faille93414743fa_ille
fails85631483fa_ils
fain75840563fa_i_n
faint85837063fa_int
fair76332523fa_i_r
fairly125610013fa_irly
fairs85825443fa_irs
fairy115318283fa_iry
faith115620853fa_ith
fajita1635923fajita
fajitas1734253fajitas
faking145520983faking
fakir125111493faki_r
fakirs13468083fakirs
falbala1235873falbala
fall75535313fa__ll
fallals103310193fallals
familial1366083familial
family143311703family
famine114318193famine
faming124922973faming
famish14311843famish
fancied133310603fancied
fancier123412063fancier
fancies124018783fancies
fanciful1643943fanciful
fancify1834983fancify
fancily1538253fancily
fanga96119623fanga_
fangas105017193fangas
fanion94514323fanion
fantail10310233fantail
faqir17548643faqi_r
faqirs18456033faqirs
farad95720673fa_rad
farci105919313farci__
farcie114816473farci_e
farcies125317883farcies
farcing133514003farcing
fardel104712593fardel
farfals13268503farfals
farfel124310433farfel
farina94618233farina
farinas103215243farinas
faring105231283faring
farl76338553fa__rl
fasciate1347563fasciate
fascicle1554633fascicle
fascine12510583fascine
fascism1436443fascism
fascist1239213fascist
fating105328673fating
fatwa1168063fatwa_
fatwas1249053fatwas
faucals12326563faucals
fauna84816513fauna_
faunae95210373faunae
faunas94013633faunas
fava106820263fa_va_
favas115618593fa_vas
favela1237033favela
favism1437913favism
faxing175117053faxing
faying134521073faying
fazing194418643fazing
feal713940423f__eal
fecula113310053fecula
feral85424653f_eral
feria85922713feria_
feriae95618603feriae
ferias95020393ferias
festal94213563festal
fetal85623373f_etal
fetials103711743fetials
feudal1037683feudal
fiar76427333f__iar
fiat76646643f__iat
ficin103516723fici_n
ficins113513983ficins
fiducial1443263fiducial
fil65447143f__i_l
fila74729133f__ila
filarial1147863filarial
fill75540193f__ill
final83922033f_inal
financial1443683financial
finials103210153finials
finical1239693finical
fiscal1139333fiscal
flail85316183flai_l
floral94313813floral
fluidal1144653fluidal
fluvial1345363fluvial
foal76630923f__oal
foci94521013foci__
foetal9311883foetal
foil76433913f_oi_l
folia83618933folia_
foliar93210973foliar
fontal9313143fontal
formal113215203formal
foveal1237703foveal
fracas11311993frac_as
fractals1346133fractals
frail85220213frai_l
frazil1847223frazi_l
friar85414273f_riar
frill84917563f_rill
frugal1036393frugal
fuci95720313fuci__
fucoidal1443783fucoidal
fugal95613033f_ugal
fungal10388733fungal
fusil84715323fusi_l
fuzil173810703fuzi_l
gavials1136603gavials
gayal9312713ga_yal
genial74917613genial
gharial1137343gharial
glial66715433_glial
hadal95518123ha_dal
haemal113811643haemal
hail74839063ha_i_l
halal85623593ha_lal
hallal94415563hallal
hamal104623113ha_mal
hammal134512063hammal
hartal9415473hartal
ilial55317843_ilial
incisal947373incisal
ischial1246423ischial
jacals1539873jac_als
jackals2036893jackals
jail115529093ja_i_l
jovial1636543jovial
kaiak8310353ka_iak
kail85131493ka_i_l
kalian10312163kalian
labia75219013labia_
labials9299873labials
lacier84020093lacier
lacily11612763lacily
lacing94626233lacing
lacrimal1244443lacrimal
lactam10310943lactam
lacteal966813lacteal
lacunal9136553lacunal
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
laminal94113633laminal
lanital7310913lanital
lariat6629043lariat
larval948503larval
local74820273loc_al
lochial1257083lochial
macaw12311763mac_aw
macing114221553macing
macula103013673macula
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magical1239783magical
mail65543453ma_i_l
maill74420793ma_ill
mammal95112753mammal
mania75634153mania_
maniac103917973maniac
manias84029033manias
manila84518303manila
manual8313463manual
maria75032883maria_
marital92314183marital
martial92415413martial
matinal9312603matinal
maximal18347093maximal
medial93819863medial
menial84223033menial
mesial84818083mesial
nachas114914193nachas
nadiral836343nadiral
naiad6313403na_iad
nail45838653na_i_l
narwal938943narwal
nasal56217593na_sal
natal53921493na_tal
naval85315833na_val
nuchal11218873nuchal
octal71214723_octal
official1644893official
ovarial1037613ovarial
paca85132243pac_a_
pacas96029403pac_as
pacha126518063pacha_
pachas135017143pachas
pacier105018683pacier
pacify1667473pacify
pacing114522753pacing
paginal10269493paginal
pail66141833pa_i_l
paleal84716673paleal
pallial92911253pallial
palpal104112053palpal
papal95820673pa_pal
pariah114320583pariah
parian83223963parian
parral85517533parral
partial92616263partial
pascal10812373pascal
paschal14157243paschal
pausal81511963pausal
penial84120893penial
phial10313203_phial
pial65636703__pial
pical95524373pic_al
plical10411683plical
racially1339623racially
racier85120973racier
racily11715173racily
racing95030533racing
racism103214193racism
racist82822793racist
radiale83813523radiale
radials83614643radials
radian74117273radian
radical103312793radical
raia46638383ra_ia_
raias54631123ra_ias
rail46147763ra_i_l
ramal74622243ra_mal
rascal8511123rascal
ratal55025113ra_tal
recital9412163recital
recoal84117973recoal
rectal84418133rectal
redial74923113redial
retial64724993retial
rial45938093__rial
rictal83113183rictal
sabal75422483sa_bal
sacra74516993sacra_
sacrals93311793sacrals
sahiwal1344443sahiwal
sail45447163sa_i_l
salal55425703sa_lal
sambal105215183sambal
samiel8313333samiel
sandal73317283sandal
serial64625863serial
sial45938833__sial
socials999633socials
spatial9310323spatial
special11310303special
tacit76333673taci_t
tacitly1236223tacitly
tactical1248843tactical
tactual936203tactual
tafia84215493tafia_
tafias93111963tafias
tail45443653ta_i_l
tamal73522623ta_mal
tarnal63716503tarnal
tarsal63315273tarsal
tectal83713253tectal
telial65815363telial
tibial849843tibial
tical76021493tic_al
trial54926353_trial
trifacial1444693trifacial
uncia75015163uncia_
unciae83215313unciae
uncials92510523uncials
uncinal959963uncinal
uracil8311543uraci_l
urial54823023_urial
vaccinal1544903vaccinal
vacua10510463vacua_
vagal94613633va_gal
vaginal11288403vaginal
vail75432553va_i_l
vakil1259793vaki_l
valval12398863valval
vandal103713833vandal
varia85824203varia_
varias95019903varias
vasal85516293va_sal
vassal979243vassal
vatical1239983vatical
venial94218283venial
vial76731093__vial
vicinal12268543vicinal
vocal104715643voc_al
wadmal1237283wadmal
wail75238823wa_i_l
xenial133414903xenial
zamia165115213zamia_
zamias174212923zamias
zoarial1646923zoarial

Search took 6 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.406440125.6
2DLD Change Limit1127164915.06322262.7
3Display Results4914910.1702888.2
 (SQL Overall)1786914915.63931688.4
 
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.