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

263 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
fecials12351033(None) 
facials123310741facials
fecial114714621fecial_
fetials103711741fetials
aecial84817312aecial_
aerials74017552aerials
decals93717712dec_als
decimals1345862decimals
decrials1137132decrials
denials84114132denials
facial113615632facial_
facias113415802facia_s
fecal105119212fec_al_
ferals94216642fe_rals
ferial94621252ferial_
ferias95020392feria_s
fetial95716192fetial_
fetiales11319612fetiales
fetialis11358662fetialis
finials103210152finials
medials103914742medials
menials94015692menials
recitals1039772recitals
recoals94214632recoals
redials84416882redials
serials73919752serials
socials999632socials
specials1238032specials
uncials92510522uncials
acetals93411353acetals
aecia73819283aecia__
aerial64625713aerial_
apicals1159923apicals
asocials1075683asocials
becalm1239203bec_alm
becalms1335743bec_alms
becaps123811403bec_aps
bechalk1845813bechalk
bechalks1944793bechalks
becrawls1543623becrawls
bewails1277553bewails
bezils1711310603bezi_ls
burials93612083burials
cecal94619113cec_al_
ceils75019403ce_i_ls
celiacs11157893celiacs
centals94317053centals
cereals9313173cereals
cerias83321983ceria_s
coals76129603__coals
deals65435343de__als
decafs124010883dec_afs
decal85523233dec_al_
decays124612913dec_ays
deciare10710663deciare
deciares11510633deciares
decibels1344523decibels
decides114217653decides
decile94619213deci_le
deciles104417723deciles
decimal1238083decimal_
deckels14367363deckels
declass1038733declass
declaws1336253declaws
decrial10310323decrial_
deils65722863de_i_ls
denial74720513denial_
dentals83915393dentals
derails84216393derails
details84214043details
devils104412813devi_ls
devisals1245613devisals
dials64925343__dials
eclats8313033_eclats
emails84412343_emails
equals1538703_equals
espials937093espials
evils84114263_evi_ls
facia103218463facia__
faciae112913413facia_e
facially1637643facially
facies113921593faci_es
facile112514883faci_le
facings134511263facings
faecal11359813faec_al_
fails85631483f_ai_ls
fallals103310193fallals
farfals13268503farfals
fascial1258303fascial_
fascias1258413fascia_s
faucals12326563faucals
faucial1257323faucial_
feal713940423fe__al_
fears84829393fe__ars
feats86432753fe__ats
feces105625363fec__es
feckly18335963fec_kly
fecks145417853fec__ks
fecula113310053fec_ula
feculae12339203feculae
federals1247303federals
feels85223043fe__els
feigns10407753fe_igns
feints94813873fe_ints
feists94915313fe_ists
felids103111623feli_ds
felines104718073felines
fellahs13428393fellahs
fellas95116963fella_s
fells85327383fe__lls
female11310553fe_male
females12310663fe_males
fencible1545603fencible
fencibles1644093fencibles
fencings14225663fencings
fennels10387903fennels
feral85424653fe_ral_
ferbams1435743ferbams
feria85922713feria__
feriae95618603feria_e
ferrels10248623ferrels
ferulas103110753ferulas
festal94213563festal_
festivals1543373festivals
fetal85623373fe_tal_
fetas85624403fe_ta_s
fetidly1435013fetidly
feuars938653fe_uars
feudal1037683feudal_
fiars86720833f__iars
fiats85324483f__iats
ficins113513983fici_ns
filial93013253filial_
fills84632373f__ills
fils75838703f__i_ls
finals94316163f_inals
finial92814183finial_
fiscals1238003fiscals
flails94313003flai_ls
florals104210063florals
foals85721693f__oals
focal104917673foc_al_
foils85025813f_oi_ls
formals123312893formals
fractals1346133fractals
frails93716473frai_ls
friars93812093f_riars
frills94414223f_rills
fungals11276783fungals
fusils93912343fusi_ls
fuzils18407963fuzi_ls
gavials1136603gavials
genial74917613genial_
genitals937243genitals
gremials1136133gremials
heals85733463he__als
heils85222193he_i_ls
herbals122710613herbals
jacals1539873jac_als
jackals2036893jackals
jezails2334163jezails
kevils13358333kevi_ls
keypals1634353keypals
labials9299873labials
legals73412733le_gals
lethals1038113lethals
locals83714503loc_als
meals75933383me__als
meccas1239493mecca_s
medals94218063me_dals
medial93819863medial_
medians103214213medians
medias93620783media_s
medicals1349363medicals
menial84223033menial_
mescals112911573mescals
mesial84818083mesial_
metals84520893me_tals
meticals12310763meticals
mezcals20246543mezcals
nectars938463nectars
nuchals12216943nuchals
officials1743403officials
peals75235493pe__als
pecans101515833pec_ans
pechans14810503pechans
pedals94316033pe_dals
pencils113011773penci_ls
penial84120893penial_
perils84121853peri_ls
petals84719813pe_tals
phials1158873_phials
racial83419243racial_
radials83614643radials
reals55038653re__als
rebills93510623rebills
recall83815733rec_all
recalls92613623recalls
recaps103615733rec_aps
recipes113314463recipes
recital9412173recital_
recites93524583recites
recits83621353reci_ts
reclads1049993reclads
recoal84117983recoal_
recoats92616643recoats
recoils93814873recoils
rectal84418143rectal_
recusals1056403recusals
redial74923113redial_
redias74523603redia_s
refills103711423refills
remails94714563remails
renails74917263renails
rentals74017483rentals
reoils64516873reoi_ls
repeals94014533repeals
resails74616743resails
reseals73917683reseals
retails74718973retails
retial64724993retial_
retinals85612963retinals
retrials8510823retrials
reveals103812733reveals
revisals1136813revisals
revivals1435433revivals
rials55026673__rials
sacrals93311793sacrals
seals54839703se__als
seconals1047053seconals
secpars1138413secpars
sendals81912273sendals
sepals85217383se_pals
sepias83616103sepia_s
serails73318363serails
serial64625863serial_
servals103410753servals
sials54227243__sials
social8813333social_
special11310303special_
teals56234133te__als
tectal83713253tectal_
telial65815363telial_
tenails73713923tenails
tenias64720073tenia_s
tepals85415043te_pals
tertials8510073tertials
ticals83214713tic_als
trials64319883_trials
uncial83715223uncial_
urials64415193_urials
veals84926193ve__als
veils84918803ve_i_ls
venial94218283venial_
verbals121910743verbals
vestals104612333vestals
vexils1647173vexi_ls
vials85822383__vials
vocals113811583voc_als
weals85428743we__als
xenial133414903xenial_
xenias133712973xenia_s
zeals145320853ze__als

Search took 9 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 Limit1340272637.96616824.9
3Display Results2632630.0962739.6
 (SQL Overall)1786912638.46821101.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.