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

207 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
decrial1031032(None) 
decrials1137131decrials
aecial84817312aec_ial
aerial64625712ae_rial
decadal1137242decadal
decal85523232dec__al
decanal1038112decanal
decimal1238082decimal
decretal1146352decretal
decried112612852decried
decrier102713552decrier
decries103319802decries
denial74720512de_nial
deprival1444602deprival
derail74218812de_rail
dermal93614342de_rmal
detrital946572detrital
fecial114714622fec_ial
ferial94621252fe_rial
retrial7615552retrial
serial64625862se_rial
accrual1144553accrual
aecia73819283aec_ia_
aecidial1147253aecidial
aerials74017553ae_rials
atrial65418943_atrial
becrawl1444583becrawl
becrime1387053becrime
bedrail1037253bedrail
bestial9311643bestial
breccial1444693breccial
burial84117623_burial
cecal94619113cec__al
cercal10314123ce_rcal
cercarial1346033cercarial
cereal8315833ce_real
ceria75125353ce_ria_
cerias83321983ce_rias
chorial124214143chorial
craal74117753__craal
curial84019153_curial
deal56347413de___al
dearie73319813deari_e
dearies83526273dearies
deasil71110983deasi_l
debride1138593debride
debrief1337623debrief
debris93311493debri_s
decaf114919443dec__af
decals93717713dec__als
decay114718483dec__ay
deceit93018213decei_t
deceits102810883deceits
deceive1337813deceive
decennial1244823decennial
deciare10710663dec_iare
decibel1235993decibel
decide104116873dec_ide
decidual1244203decidual
decile94619213dec_ile
decimals1345863decimals
deckel134911043dec_kel
decking153915593decking
declaim1247363declaim
declaw1266703dec_law
decline103716613decline
decrease1136563decrease
decree93117783decr_ee
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
decretals1245093decretals
decriers11299733decriers
decrown13206053decrown
decry115514353decr__y
decrying15237413decrying
decrypt1545703decrypt
decuman1236573decuman
decuries11312223decuries
decurion1146623decurion
dedal75719023de__dal
deferral1244353deferral
defrag1136463defr_ag
defray1337643defr_ay
defrayal1542613defrayal
deicidal1245713deicidal
deifical1445543deifical
deil56231623de__i_l
deliria868303deliria_
demersal1145263demersal
demurral1143943demurral
denials84114133de_nials
dental74319173de_ntal
dentil74017883denti_l
dentinal939503dentinal
deposal1037153deposal
deprivals1543533deprivals
deprive1338303deprive
derails84216393de_rails
derat65044083de_r_at
deray95024183de_r_ay
deride84420033de_ride
derive103817043de_rive
derma84918513de_rma_
dermas94116813de_rmas
derrick1435803derrick
derries83124623derries
derris73615273derri_s
describe1346243describe
descried1248073descried
descrier1157623descrier
descries11311923descries
despisal1144673despisal
detail74516433detai_l
detrain8412253detrain
deverbal1444483deverbal
devil94714733de_vi_l
devisal1136913devisal
dextral1577003dextral
dial55935063d___ial
dicrotal1146823dicrotal
diurnal844883diurnal
doctorial1246693doctorial
doctrinal1243913doctrinal
dorsal74613943d_orsal
drail65020973d__rail
drill64718263d__rill
ducal84816423duc__al
ductal938993duc_tal
dural64923893d_ur_al
durian7312003d_urian
espial839543_espial
facial113615633fac_ial
fecal105119213fec__al
fecials123510333fec_ials
feral85424653fe_r_al
feria85922713fe_ria_
feriae95618603fe_riae
ferias95020393fe_rias
fetial95716193fe_tial
genial74917613ge_nial
gharial1137343gharial
hectical1547933hectical
herbal112513493he_rbal
hernial10310433hernial
ischial1246423ischial
kerria10339913kerria_
kerrias11289513kerrias
lacrimal1244443lacrimal
lochial1257083lochial
medial93819863me_dial
memorial1249523memorial
menial84223033me_nial
mercurial1354733mercurial
mesial84818083me_sial
metrical12311593metrical
narial6317953_narial
nectarial1147103nectarial
neural6311993neur_al
ovarial1037613ovarial
penial84120893pe_nial
peril75425953pe_ri_l
pretrial10511983pretrial
rachial122012173rachial
racial83419243rac_ial
reburial1046203reburial
recital9412163recital
recoal84117973rec_oal
recoil84016723recoi_l
rectal84418133rec_tal
rectorial11119893rectorial
recusal968673recusal
redial74923113re_dial
redrill857893redrill
reprisal1045903reprisal
retial64724993re_tial
retral64419743retr_al
retrials8510823retrials
rial45938093___rial
sacral83414413sacr_al
scribal1137963_scribal
seconal9310073seconal
sectorial111110013sectorial
serail64222673se_rail
seral56336383se_r_al
serials73919743se_rials
serval93913413se_rval
social8813333soc_ial
special11310303spec_ial
tectal83713253tec_tal
tectorial11119033tectorial
telial65815363te_lial
tenurial847703tenurial
tergal72912833te_rgal
tertial7313863tertial
trial54926353__trial
uncial83715223unc_ial
urial54823023__urial
uxorial1446323uxorial
vectorial14147403vectorial
venial94218283ve_nial
verbal112513663ve_rbal
vernal93514213ve_rnal
versal93013753ve_rsal
vicarial1347793vicarial
xenial133414903xe_nial
zoarial1646923zoarial

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.423422437.4
2DLD Change Limit1340272077.00019146.7
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.49923828.6
 
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.