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

173 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
scandal103867(None) 
sandal73317281s_andal
scandals1136991scandals
acaudal1045782acaudal
canal75428042_can_al
cantal84122032_cantal
caudal91611482_caudal
sandals82715202s_andals
scandaled1344662scandaled
scandia1038062scandia
scandias1137862scandias
scandic1237002scandic
sendal73314992s_endal
vandal103713832_vandal
anal48037523__an_al
annal56520763__annal
anodal72512123__anodal
banal75925993_ban_al
banda85223103_banda_
bandas95120543_bandas
bicaudal1343423bicaudal
cabal95222153_ca_bal
caecal103713733_caecal
calendal1145383_calendal
canals84421663_can_als
cancan10314103_cancan
cancel105316683_cancel
candela1089743_candela
candid104517853_candid
candidal12367733_candidal
candle94321483_candle
candor94516423_candor
candy115119823_cand_y
canful11610263_canful
canna75919333_canna_
cannas84518403_cannas
cannel84216403_cannel
canola8313623_canola
cantala94114673_cantala
cantals93919573_cantals
canthal12410053_canthal
canula8312963_canula
canvas113813333_canvas
carnal83919203_carnal
carpal103716253_carpal
casual81112863_casual
caudad10157673_caudad
causal81413203_causal
cental84420963_cental
cranial92114683cranial
credal9311673_credal
cuneal8611513_cuneal
daedal849083_daedal
decadal1137243deca_dal
decanal1038113decan_al
gonadal956523gonadal
grandad1038453grandad
grandam1139393grandam
hadal95518123_ha_dal
handax1749583_handax
landau7310613_landau
mandala10310213_mandala
manual8313463_manual
monadal1047893monadal
octantal1044563octantal
panda85022613_panda_
pandas95521963_pandas
poundal1036403poundal
prandial1149643prandial
quantal16367893quantal
randan7315253_randan
sabal75422483s_a_bal
sacral83414413s_acral
salal55425703s_a_lal
sambal105215183s_ambal
sand55338473s_and__
sandable111612823s_andable
sandaled1039243s_andaled
sandbag11106243s_andbag
sandbar10108193s_andbar
sanddab1144923s_anddab
sanded84920613s_anded
sander74828533s_ander
sandfly1435643s_andfly
sandhi1038193s_andhi
sandman10310173s_andman
sands65228583s_and_s
sandy94221133s_and_y
sanga66023793s_anga_
sangar73617683s_angar
sangas75222653s_angas
sanjak1735693s_anjak
sansar63613393s_ansar
santol64515243s_antol
sardar73013173s_ardar
scad75725773sca_d__
scads85419963sca_d_s
scalade10359263scalade
scalado10276473scalado
scalar83612433sca_lar
scald84818123scald__
scalded11409763scalded
scaldic1235943scaldic
scalds94813693scald_s
scall74420373sca__ll
scalpel11377713scalpel
scan65530453scan___
scandaling14195453scandaling
scandalise1344893scandalise
scandalize2244613scandalize
scandalled1443073scandalled
scandalous1343593scandalous
scandent1148493scandent
scandium1365693scandium
scannable1345643scannable
scanned104110893scanned
scanner94411813scanner
scans74625103scan__s
scant79735073scan__t
scanted104114393scanted
scanter94215183scanter
scantily1337583scantily
scantly12419553scantly
scants85219723scan_ts
scanty114014663scan_ty
scapula1136343scapula
scarab10310063sca_rab
scena74815783scen_a_
scenas84114703scen_as
scend85516293scend__
scended11329873scended
scends95213003scend_s
scenical1247133scenical
scleral937863scleral
scrannel1044033scrannel
scribal1137963scribal
scrotal938493scrotal
seconal9310073secon_al
sendals81912263s_endals
shandy134710033shand_y
signal73711483sign_al
slander84015443slander
sonantal886263sonantal
spacial1138763spacial
spancel1147363spancel
spandex1735833spandex
spandrel1144063spandrel
spandril1144093spandril
spaniel948923spaniel
spathal1236263spathal
spatial9310323spatial
spinal84915313spin_al
sponsal946343sponsal
stand65923283stand__
standard1046253standard
standby1334423standby
standee83514513standee
stander84316163stander
standpat1145723standpat
stands75118053stand_s
standup1034353standup
stanol6310723stan_ol
stanza1537073stanza_
stanzas1636363stanzas
statal61613223sta_tal
subnodal1145043subnodal
sundae7312873s_undae
sundial859863s_undial
swanpan1243693swanpan
synodal1145743synodal
vanda94515923_vanda_
vandals113211663_vandals
vandas103915993_vandas

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.423422437.4
2DLD Change Limit1340271736.12321889.1
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.60927037.5
 
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.