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

226 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
fascias125841(None) 
facias113415801fa_cias
fascia1148701fascia_
fasciae1247521fasciae
fascial1258301fascial
cassias93514342cassias
facia103218462fa_cia_
faciae112913412fa_ciae
facial113615632fa_cial
facials123310742fa_cials
facies113921592fa_cies
fancies124018782fancies
farcies125317882farcies
fasces114914542fasc_es
fasciate1347562fasciate
fascine12510582fascine
fascines13310142fascines
fascism1436442fascism
fascisms1545662fascisms
fascist1239212fascist
fascists1336612fascists
fascitis1346012fascitis
faucial1257322faucial
abasias9711013abas_ias
acacias11510403acacias
acids87121003_a_cids
aecia73819283_aecia_
aecial84817313_aecial
agrias74315393_agrias
alcids94812293_alcids
alias55834603_a_lias
amias75831473_a_mias
arias55438023_a_rias
asanas6514113_asanas
asci66519143_asci__
ascites9312603_ascites
ascots85312513_ascots
ascus75013583_asc_us
asdics9439863_asdics
asocial998653_asocial
asocials1075683_asocials
aspics104211563_aspics
aspis74618143_aspi_s
assais6711963_assais
barcas101016603barc_as
basics104915123bas_ics
basils85717473bas_ils
basins85722763bas_ins
basis75429863bas_i_s
boccias13307193boccias
cacas95627983ca_c_as
canchas143212403canchas
capias10318353ca_pias
cardias10715113cardias
casabas1139983casabas
casas75327843cas__as
casavas1237813casavas
cascaras1237703cascaras
caseins93115053caseins
casitas93312043casitas
cassia83714763cassia_
cassinas103610633cassinas
cassis84818853cassi_s
dachas124113253da_chas
dahlias1135723dahlias
dashis104414393dashi_s
dassies84418663dassies
datchas1347423datchas
easies64126633eas_ies
episcias1244883episcias
fabliau1244903fabliau
fabrics1436093fabrics
facers115519443fa_cers
faces106439433fa_c_es
facets116316653fa_cets
facile112514883fa_cile
facing125321573fa_cing
facings134511263fa_cings
facts107021893fa_c_ts
fadeins1168503fadeins
faecal11359813faec_al
faeces114713123faec_es
faenas94412763fa_enas
faeries104118993faeries
fagins10513863fa_gins
fails85631483fa__ils
fairies103516043fairies
fairs85825443fa__irs
fajitas1734253fajitas
fakirs13468083fa_kirs
falces115216003falc_es
falcons1239123falcons
falsies103515013falsies
fancied133310603fancied
fancier123412063fancier
fanciers13358083fanciers
fanciest133612713fanciest
fancify1834983fancify
fancily1538253fancily
fanegas1145713fanegas
fanfics1535173fanfics
fangas105017193fa_ngas
fannies103415643fannies
faqirs18456033fa_qirs
faquirs1943863faquirs
farcers124713443farcers
farces115223323farc_es
farci105919313farci__
farcical1546953farcical
farcie114816473farci_e
farcing133514003farcing
farinas103215233farinas
fasciated1546133fasciated
fascicle1554633fascicle
fascicles1664263fascicles
fasciitis1443543fasciitis
fascinate1447763fascinate
fascinates1547153fascinates
fashes124524023fas_hes
fashing144918793fashing
fashion1337843fashion
fashions1437243fashions
fashious1446123fashious
fastens105511753fastens
fasting114522833fasting
fastings124011943fastings
fasts86429683fas__ts
fatties103018203fatties
fatwas1249053fa_twas
faucal11339963fauc_al
faucals12326563faucals
fauces114916153fauc_es
faucets12578443faucets
faunas94013633fa_unas
favas115618593fa__vas
favelas1337023favelas
fecial114714623f_ecial
fecials123510333f_ecials
ferias95020393f_erias
fescues1236783fescues
fiascoes13134923fiascoes
fiascos12124743fiasc_os
ficins113513983f_icins
fincas113512073finc_as
fiscal1139333fisc_al
fiscals1238003fiscals
fiscs105311883fisc__s
focaccias1551803focaccias
fossas94610703fos_sas
fossils10379013fossils
fracas11311993frac_as
funkias1435383funkias
fusains1038363fusains
fuscous1256673fuscous
fusils93912343fus_ils
fustian1036903fustian
fustians1146403fustians
fustics1279593fustics
gambias125010733gambias
gascons10289103gascons
gaskins123510773gaskins
jasmins1637083jasmins
jassids1586143jassids
kalmias1347973kalmias
kashas133311903kas_has
katcinas1434513katcinas
lamias85020613la_mias
lascar868573lasc_ar
lascars979013lascars
lashins103915153lashins
lassies74420103lassies
lassis65216703lassi_s
latrias71913213latrias
maffias15327283maffias
mafias113913573ma_fias
manias84029033ma_nias
masalas9312053masalas
masas75630413mas__as
mascaras1237693mascaras
mascons113411583mascons
mascots113910343mascots
mashies12318253mashies
masjids17175403masjids
massas85116463mas_sas
massifs1237743massifs
mastics112614783mastics
misbias1139083misbias
muscids12187973muscids
nachas114914193na_chas
nancies93516843nancies
nasial6413283nas_ial
nasties73520493nasties
oasis56422553oas_i_s
pacas96029403pa_c_as
pachas135017143pa_chas
pascal10812373pasc_al
pascals11610013pascals
paschal14157243paschal
paschals1566473paschals
pashas115117063pas_has
pastas85422873pas_tas
pasties94529813pasties
pastils94416173pastils
pastinas103712153pastinas
pastis84924323pasti_s
piscinas1275483piscinas
quassias1754933quassias
racial83419243ra_cial
raffias13237713raffias
raias54631123ra__ias
raphias123511083raphias
rascal8511123rasc_al
rascals959663rascals
salvias10279933salvias
sarcinas1039273sarcinas
sasins64923103sas_ins
sassies74719263sassies
taenias7311283taenias
taffias13377413taffias
tafias93111963ta_fias
tarsias74013373tarsias
tassies74918933tassies
vaccinas1544973vaccinas
varias95019903va_rias
yautias1046333yautias
zamias174212923za_mias

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.420425454.8
2DLD Change Limit1340272266.58020368.8
3Display Results2262260.0762973.7
 (SQL Overall)1786912267.07625253.1
 
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.