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

142 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
faucial125732(None) 
facial113615631fa_cial
fascial1258301fascial
faucal11339961fauc_al
aecial84817312_aecial
audial7312992_audial
crucial1157892crucial
facia103218462fa_cia_
faciae112913412fa_ciae
facials123310742fa_cials
facias113415802fa_cias
faecal11359812faec_al
farcical1546952farcical
fascia1148702fascia_
fasciae1247522fasciae
fascias1258412fascias
faucals12326562fauc_als
faunal94711592fau_nal
fecial114714622f_ecial
fiducial1443262fiducial
fluvial1345362fluvial
racial83419242ra_cial
aecia73819283_aecia_
aerial64625713_aerial
apical10913903_apical
asocial998653asocial
atrial65418943_atrial
aural54428963_au_ral
axial124515193_a_xial
bifacial15105273bifa_cial
buccal1248243_buccal
burial84117623_burial
caecal103713733caec_al
cambial134010753cambial
caudal91611483cau_dal
causal81413203cau_sal
crucian1146283crucian
curial84019153_curial
ducal84816423_duc_al
ductal938993_ductal
eluvial1045853eluvial
exuvial1744253exuvial
fabliau1244903fabliau
facially1637643fa_cially
facies113921593fa_cies
facile112514883fa_cile
facing125321573fa_cing
factual1246723factual
facula112912233facula_
faculae123210353faculae
facular122810443facular
fail74840243fa__i_l
fallal93612693fa_llal
familial1366073familial
fancied133310603fancied
fancier123412063fancier
fancies124018783fancies
fanciful1643943fanciful
fancify1834983fancify
fancily1538253fancily
fantail10310233fantail
farci105919313farci__
farcie114816473farci_e
farcies125317883farcies
farcing133514003farcing
farfal123410183fa_rfal
fasciate1347563fasciate
fascicle1554633fascicle
fascine12510583fascine
fascism1436443fascism
fascist1239213fascist
fatal84819373fa__tal
fauces114916153fauc_es
faucet115816553fauc_et
faucets12578443faucets
fauna84816513fau_na_
faunae95210373fau_nae
faunas94013633fau_nas
fauvism1545223fauvism
fauvist1336663fauvist
fecal105119213f_ec_al
fecials123510333f_ecials
ferial94621253f_erial
fetial95716193f_etial
feudal1037683feu_dal
filial93013253f_ilial
financial1443673financial
finial92814183f_inial
finical1239683finical
fiscal1139333fisc_al
fluidal1144653fluidal
focal104917673f_oc_al
fractal1237623fractal
frugal1036393fru_gal
fuci95720313f_uci__
fucoidal1443783f_ucoidal
fugal95613033f_u_gal
fungal10388733f_ungal
fusil84715323f_usi_l
fuzil173810703f_uzi_l
gavial10310083ga_vial
glacial1038143glacial
jacal14313703ja_c_al
jackal1937613ja_ckal
labial84714333la_bial
lacunal9136553lacunal
laical8312323laic_al
magical1239783magical
manurial1047783manurial
martial92415413martial
narial6317953na_rial
nasial6413283na_sial
nauplial1042903nauplial
nautical1057703nautical
nuchal11218873_nuchal
official1644893official
pallial92911253pallial
partial92616263partial
pascal10812373pasc_al
paschal14157243paschal
paucity1435823paucity
pausal81511963pau_sal
pluvial1245433pluvial
rachial122012173rachial
radial74020393ra_dial
radical103312793radical
rascal8511123rasc_al
raucity1235853raucity
sacral83414413sa_cral
saucier9810283saucier
saucily1237913saucily
saucing10311003saucing
saurian739913saurian
social8813333_social
spacial1138763spacial
special11310303special
uncial83715223_uncial
urial54823023__urial
vaccinal1544903vaccinal
vatical1239983vatical
yautia937243yautia_
yautias1046333yautias

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271426.64020184.8
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.84226116.8
 
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.