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

211 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
faucals1232656(None) 
faucal11339961faucal_
causals91411182causals
facials123310742facials
faecal11359812faecal_
fallals103310192fallals
farfals13268502farfals
fauces114916152fauc_es
faucets12578442faucets
faucial1257322faucial_
faunal94711592faunal_
faunas94013632fauna_s
fiscals1238002fiscals
jacals1539872ja_cals
pascals11610012pascals
rascals959662rascals
aals49941143_a__als
acyls104211523_a_cyls
annals66415923_annals
apicals1159923apicals
appals104812943_appals
argals75517713_argals
audads8167103_audads
aural54428963_aural_
auras55932563_aura_s
baals76122703ba__als
barcas101016603barca_s
bubals103513843_bubals
cabals104020153ca_bals
cacaos104616183ca_caos
cacas95627983ca_ca_s
caecal103713733caecal_
calcars11312653calcars
canals84421663ca_nals
cancans11311873cancans
cancels114113313cancels
cantals93919573cantals
caracals12310743caracals
carcass11310513carcass
carcels114516063carcels
carpals113414623carpals
casuals91410523casuals
catcall1139153catcall
catcalls1238323catcalls
caucus1039613cauc_us
caudal91611483caudal_
cauls75727773cau__ls
causal81413203causal_
decals93717713_decals
duals65620083_du_als
ducal84816423_ducal_
ducats95011763_ducats
equals1538693equ_als
facade1238803fa_cade
facades1339033fa_cades
facers115519443fa_cers
faces106439433fa_c_es
facets116316653fa_cets
facial113615633facial_
facias113415803fa_cias
facies113921593fa_cies
facile112514883fa_cile
facts107021893fa_c_ts
facula112912233fa_cula
faculae123210353faculae
facular122810443facular
faeces114713123faec_es
faenas94412763faena_s
fails85631483fa__ils
falbala1235873falbala
falbalas1345473falbalas
falcate12311613falcate
falces115216003falc_es
falcons1239123falcons
fallal93612693fallal_
falls85727653fa__lls
fancies124018783fancies
fancily1538253fancily
fangas105017193fanga_s
fantails1139693fantails
farads104713273fa_rads
farcers124713443farcers
farces115223323farc_es
farcies125317883farcies
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farls85731113fa__rls
fasces114914543fasc_es
fascial1258303fascial_
fascias1258413fascias
fatal84819373fa_tal_
fatwas1249053fatwa_s
faucet115816553fauc_et
fauld95214493fau__ld
faulds10438963fau_lds
fault85428313fau__lt
faults94513553fau_lts
fauna84816513fauna__
faunae95210373fauna_e
faunally1445433faunally
fauns84516753fau__ns
fauves125610423fau_ves
favas115618593fa_va_s
favelas1337023favelas
fecal105119213f_ecal_
fecials123510333fecials
ferals94216643f_erals
fetials103711743fetials
feuars938653feu_ars
feudal1037683feudal_
finals94316163f_inals
fincas113512073finca_s
finials103210153finials
fiscal1139333fiscal_
flatcaps1563403flatcaps
flatcars1344623flatcars
flautas1036153flauta_s
florals104210063florals
foals85721693f__oals
focal104917673f_ocal_
formals123312893formals
fouls87221433fou__ls
fracas11311993fraca_s
fractals1346133fractals
frugal1036393frugal_
fucks144419253f_uc_ks
fucous11399863f_ucous
fucus105515893f_uc_us
fuels87117353f_u_els
fugal95613033f_ugal_
fulls84623523f_u_lls
fungals11276783fungals
furans94515953f_urans
furls85322053f_u_rls
fusels94412453f_usels
fusils93912343f_usils
fuzils18407963f_uzils
gauchos1345903gauchos
gavials1136603gavials
gayals1039513ga_yals
glucans1045293glucans
halals95018313ha_lals
hamals114816823ha_mals
hammals14409223hammals
hartals10313023hartals
hauls86123733hau__ls
jacal14313703ja_cal_
jacales16310323ja_cales
jackals2036893jackals
jouals1338923jou_als
labials9299873labials
laical8312323laical_
lascars979013lascars
lauans65113533lau_ans
lauras63414333laura_s
laurels746663laurels
locals83714503_locals
macaws1337023ma_caws
maculas113114023maculas
madcaps1435243madcaps
mammals10389273mammals
manuals9311213manuals
marcels113212373marcels
mauls76524953mau__ls
mescals112911553mescals
mezcals20246533mezcals
murals84016763_murals
narwals1036983narwals
nasals63312463na_sals
naturals847903naturals
nuchals12216933_nuchals
pacas96029403pa_ca_s
parcels113712663parcels
parrals94414573parrals
pascal10812373pascal_
paschals1566473paschals
pausal81511963pausal_
plurals936913plurals
radials83614633radials
radicals112610153radicals
rascal8511123rascal_
ratals64219583ra_tals
raucous938303raucous
sabals84618863sa_bals
sacrals93311793sacrals
salals65120083sa_lals
sambals115213483sambals
sandals82715203sandals
saucers93712133saucers
sauces84919503sauc_es
sauchs115112233sauc_hs
saucily1237913saucily
sauls55128123sau__ls
saunas63915433sauna_s
saurels749303saurels
soucars938423soucars
squeals1636513squeals
tamals84116633ta_mals
tarsals72512603tarsals
ticals83214713_ticals
tincals93610643tincals
toucans937583toucans
usuals637783usu_als
vandals113211663vandals
vassals1057953vassals
vocals113811583_vocals
wadmals1335513wadmals
wauchts15285283wauchts
wauls86120553wau__ls
yucas106013913_yuca_s

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.406440125.6
2DLD Change Limit1340272116.45320769.7
3Display Results2112110.0802637.5
 (SQL Overall)1786912116.93925751.7
 
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.