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 “decal” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
decal8552323(None) 
cecal94619111cecal
deal56347411de_al
decaf114919441decaf
decals93717711decals
decay114718481decay
dedal75719021dedal
ducal84816421ducal
fecal105119211fecal
aecial84817312aecial
becalm1239202becalm
becap114315052becap
caecal103713732caecal
ceca84820782ceca_
cercal10314122cercal
daedal849082daedal
dal47554952d__al
dead65434242de_ad
deaf85838402de_af
deals65435342de_als
dealt65234282de_alt
dean56039482de_an
dear55343602de_ar
debag94212302debag
debar85517862debar
decadal1137242decadal
decade104216162decade
decafs124010882decafs
decalog1136002decalog
decamp1338452decamp
decanal1038112decanal
decane93818872decane
decant93524222decant
decare93919152decare
decays124612912decays
decile94619212decile
decimal1238082decimal
deck115827752dec_k
deckel134911042deckel
deckle1312012452deckle
decks124822192decks
declaw1266702declaw
deco76125972dec_o
decor84717572decor
decos85522122decos
decoy115716312decoy
decrial10310322decrial
decry115514352decry
defat95426692defat
degas75119162degas
deil56231622de_il
del46752752de__l
delay94820632delay
dell56938202de_ll
denar65223292denar
denial74720512denial
dental74319172dental
derail74218812derail
derat65044082derat
deray95024182deray
dermal93614342dermal
desalt7518312desalt
detail74516432detail
deva85720982deva_
devas96218882devas
devel94217122devel
devil94714732devil
dewan95718042dewan
dewar95817732dewar
dewax165510852dewax
dhal86719282d_hal
dial55935062d_ial
domal85619202domal
dotal64919622dotal
dual55928172d_ual
ducat86225902ducat
ductal938992ductal
dural64923892dural
egal55119432_egal
faecal11359812faecal
feal713940422fe_al
fecial114714622fecial
feral85424652feral
fetal85623372fetal
focal104917672focal
heal75645692he_al
hemal104419802hemal
ideal65716392ide_al
jacal14313702jacal
leal46043272le_al
legal65715942legal
local74820272local
meal65643172me_al
medal86221332medal
mescal104113492mescal
metal75427382metal
mezcal19367852mezcal
peal68648102pe_al
pecan91919032pecan
pedal86022502pedal
penal75228372penal
petal76526892petal
pical95524372pical
real45750292re_al
recall83815722recall
recap95718022recap
recoal84117972recoal
rectal84418132rectal
regal65023792regal
renal55929502renal
seal45654372se_al
sepal77723002sepal
seral56336382seral
setal56430902setal
teal45546502te_al
tectal83713252tectal
tepal76319582tepal
thecal113310302thecal
tical76021492tical
veal76936812ve_al
venal85523212venal
vocal104715642vocal
weal75838682we_al
zeal135530332ze_al

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538001242.12625305.7
3Display Results1241240.0304133.3
 (SQL Overall)1786911242.48271994.8
 
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.