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

305 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
facials12331074(None) 
facial113615631facial_
facias113415801facia_s
fecials123510331fecials
facia103218462facia__
faciae112913412facia_e
facially1637642facially
facies113921592faci_es
facile112514882faci_le
facings134511262facings
fails85631482fa_i_ls
fallals103310192fallals
farfals13268502farfals
fascial1258302fascial_
fascias1258412fascia_s
faucals12326562faucals
faucial1257322faucial_
fecial114714622fecial_
fetials103711742fetials
finials103210152finials
fractals1346132fractals
gavials1136602gavials
jacals1539872jac_als
jackals2036892jackals
labials9299872labials
racial83419242racial_
radials83614632radials
sacrals93311792sacrals
socials999632socials
uncials92510522uncials
aals49941143_a__als
acacias11510403acacia_s
acetals93411353_acetals
acidly125211793_acidly
acids87121003_aci_ds
acinus8311253_acinus
acyls104211523_ac_yls
aecial84817313aecial_
aerials74017553aerials
ails45654713_a_i_ls
alias55834603_alia_s
amias75831473_amia_s
anils56326723_ani_ls
animals94111703_animals
annals66415923_annals
apicals1159923_apicals
appals104812943_appals
argals75517713_argals
arias55438023_aria_s
ariels65119373_ariels
arils58732203_ari_ls
asocials1075683asocials
avails939693_avails
avians93711563_avians
axial124515193_axial_
axils127217503_axi_ls
baals76122703ba__als
bacilli1146393bacilli
bacillus1245153bacillus
bails75933523ba_i_ls
banians9312033banians
basils85717473basi_ls
bifacial15105273bifacial_
brachials16206943brachials
burials93612083burials
cabals104020153ca_bals
cacaos104616183cac_aos
cacas95627983cac_a_s
camails11311753camails
canals84421663ca_nals
cantals93919573cantals
capias10318353capia_s
capitals12209443capitals
carpals113414623carpals
casuals91410523casuals
causals91411183causals
caviars1238623caviars
cavils114014393cavi_ls
coals76129603__coals
dachas124113253dacha_s
dacites101114593dacites
dactyls1333913dactyls
decals93717713dec_als
decimals1345863decimals
decrials1137133decrials
denials84114133denials
dials64925343__dials
espials937093espials
facade1238803fac_ade
facades1339033facades
faceable15108493faceable
facers115519443fac_ers
faces106439433fac__es
facets116316653fac_ets
faciend1334803faciend
faciends1443573faciends
facilely1644363facilely
facing125321573faci_ng
factions133013063factions
factious13239243factious
factorials1544693factorials
factors12912123factors
facts107021893fac__ts
factual1246723factual_
facula112912233fac_ula
faculae123210353faculae
facular122810443facular
fadings12469303fadings
faecal11359813faecal_
faenas94412763faena_s
fagins10513863fagi_ns
fail74840243fa_i_l_
faille93414743fa_ille
failles102914133fa_illes
faints94818783fa_ints
fairly125610013fa_irly
fairs85825443fa_i_rs
faiths124610273fa_iths
fajitas1734253fajitas
fakirs13468083faki_rs
falbala1235873falbala
falbalas1345473falbalas
fallal93612693fallal_
falls85727653fa__lls
family143311703fami_ly
famines123216263famines
fanciers13358083fanciers
fancies124018783fanci_es
fancily1538253fanci_ly
fangas105017193fanga_s
fanions103713073fanions
fantails1139693fantails
faqirs18456033faqi_rs
farads104713273fa_rads
farcical1546953farcical_
farcies125317883farci_es
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farinas103215233farinas
farls85731113fa__rls
fascia1148703fascia__
fasciae1247523fascia_e
fasciate1347563fasciate
fascicle1554633fascicle
fascicles1664263fascicles
fascines13310143fascines
fascisms1545663fascisms
fascists1336613fascists
fascitis1346013fascitis
fatal84819373fa_tal_
fatwas1249053fatwa_s
faucal11339963faucal_
faunal94711593faunal_
faunas94013633fauna_s
favas115618593fa_va_s
favelas1337023favelas
favisms1535443favisms
fecal105119213fec_al_
ferals94216643f_erals
ferial94621253ferial_
ferias95020393feria_s
fetial95716193fetial_
fetiales11319613fetiales
fetialis11358663fetialis
fiars86720833f__iars
fiats85324483f__iats
ficins113513983fici_ns
filial93013253filial_
fills84632373f__ills
fils75838693f__i_ls
finals94316163f_inals
finial92814183finial_
fiscals1238003fiscals
flails94313003flai_ls
florals104210063florals
foals85721693f__oals
focal104917673foc_al_
foils85025813f_oi_ls
formals123312893formals
fracas11311993frac_a_s
fractal1237623fractal_
frails93716473frai_ls
frazils1956123frazi_ls
friars93812093f_riars
frills94414223f_rills
fungals11276783fungals
fusils93912343fusi_ls
fuzils18407963fuzi_ls
gavial10310083gavial_
gayals1039513ga_yals
gharials1245123gharials
glacial1038143glacial_
hails85231643ha_i_ls
halals95018313ha_lals
hamals114816823ha_mals
hammals14409223hammals
hartals10313023hartals
jacal14313703jac_al_
jacales16310323jac_ales
jackal1937613jackal_
jackass2034963jackass
jails125422943ja_i_ls
kaiaks937043ka_iaks
kails95525213ka_i_ls
kalians11310183kalians
labial84714343labial_
lacily11612763laci_ly
lacings105013653lacings
lacrimals1342913lacrimals
lactams1136953lactams
lacteals1095663lacteals
laical8312323laical_
lamias85020613lamia_s
laminals10339303laminals
lanitals837723lanitals
lariats7615053lariats
locals83714503loc_als
macaws1337023mac_aws
maculas113114023maculas
mafias113913573mafia_s
magians10310753magians
maills84215283ma_ills
mails76037783ma_i_ls
mammals10389273mammals
maniacs114313063maniacs
manias84029033mania_s
manilas93915873manilas
manuals9311213manuals
maximals19325223maximals
medials103914733medials
menials94015683menials
nachas114914193nacha_s
naiads739013na_iads
nails55730403na_i_ls
narial6317953narial_
narwals1036983narwals
nasals63312463na_sals
nasial6413283nasial_
nuchals12216933nuchals
officials1743403officials
pacas96029403pac_a_s
pachas135017143pacha_s
pails75833063pa_i_ls
pariahs123812343pariahs
parians93519733parians
parrals94414573parrals
partials101911953partials
pascals11610013pascals
paschals1566473paschals
phials1158873_phials
rachial122012173rachial_
racialism1348333racialism
racialist11411203racialist
racially1339623racially
racily11715173raci_ly
racings105015133racings
racisms112310813racisms
racists92613323racists
radial74020393radial_
radiale83813523radiale
radians83013823radians
radicals112610153radicals
raias54631123ra_ia_s
rails55937403ra_i_ls
rascals959663rascals
ratals64219583ra_tals
recitals1039763recitals
recoals94214623recoals
redials84416883redials
rials55026673__rials
sabals84618863sa_bals
sacral83414413sacral_
sahiwals1443643sahiwals
sails55738103sa_i_ls
salals65120083sa_lals
sambals115213483sambals
samiels939763samiels
sandals82715203sandals
serials73919743serials
sials54227243__sials
social8813333social_
spacial1138763spacial_
specials1238033specials
tacitly1236223tacitly
tafias93111963tafia_s
tails55634193ta_i_ls
tamals84116633ta_mals
tarsals72512603tarsals
ticals83214713tic_als
trials64319883_trials
trifacials1553013trifacials
uncial83715223uncial_
uracils939373uraci_ls
urials64415193_urials
vails85825933va_i_ls
vakils1337593vaki_ls
vandals113211663vandals
varias95019903varia_s
vassals1057953vassals
vials85822383__vials
vocals113811583voc_als
wadmals1335513wadmals
wails86631483wa_i_ls
zamias174212923zamia_s

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.1401276364.3
2DLD Change Limit1340273057.23318529.9
3Display Results3053050.0933279.6
 (SQL Overall)1786913057.46623934.0
 
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.