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

219 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
dastard927970(None) 
bastard103012421bastard
dastards10278081dastards
bastards113310312bastards
bastardy14326002bastardy
bustard10389722bustard
costard104113352costard
custard10389972custard
dastardly14273802dastardly
datary10310242da_tary
daystar1143442daystar_
daystars1243902daystars
discard11310212discard
dotard839052d_otard
eastward1244992eastward
mustard10359532mustard
aboard9312613_aboard
afeard1058263_afeard
altar55520643_altar_
altars64518153_altars
ascared10399523_ascared
ascarid103910723_ascarid
aster55434893_aster_
astern64815813_astern
asters65631603_asters
astir55517093_astir_
astral66919283_astral
astray95615543_astray
aswarm11107913_aswarm
attar56516693_attar_
attars64515313_attars
award97118043_a_ward
bastardly15264293bastardly
basted95227233bast_ed
baster85333593baster_
basters94930303basters
bayard124411663ba_yard
brassard1144683brassard
bustards11308513bustards
cabstand1344413cabstand
canard9314763ca_nard
cascara1138313cascara
caster85232573caster_
casters94729903casters
castled104311513castled
castor84418533castor_
castors94919443castors
coastward1543553coastward
costar85518613costar_
costards113510793costards
costars94218013costars
custards11338393custards
custardy14314903custardy
dabster1036703dabster_
dabsters1137053dabsters
dafter104813343dafter_
damar84117743da_mar_
damars93815003da_mars
dammar11438903dammar_
dammars12308193dammars
darbar959953darbar_
darbars10510093darbars
dartboard1344253dartboard
darted84620923dart_ed
darter75320363darter_
darters84017603darters
dartled9409853dartled
dashboard1643803dashboard
dashed115920563das_hed
dasher104318983dasher_
dashers115016863dashers
dasyure1153823dasyure
data56026653da_ta__
dated75530993da_t_ed
dater65332313da_ter_
daters74827373da_ters
datura738033da_tura
dauted84114933daut_ed
dawted11489683dawt_ed
daycare1355093daycare
daymare1375633daymare
debeard1137353debeard
desand84812633des_and
destain8412083destain
diastase946603diastase
diaster82813313diaster_
diasters92913183diasters
diastral946993diastral
diehard1237053diehard
dietary1158663dietary
disarm9310473dis_arm
disband1138243disband
disbar938513disbar_
disbars10310323disbars
discards1238913discards
discord1139993discord
dispart101115283dispart
distaff1467683distaff
distain8313783distain
distal73615773dista_l
distant83519953distant
distend93312073distend
distort81120333distort
disturb1046233disturb
dotards937253d_otards
dullard936603dullard
dusted83918373dust_ed
duster74919723duster_
dusters84918363dusters
dustrag945363dustrag
easter65027983easter_
eastern74412533eastern
easters75125683easters
eastwards1344253eastwards
fasted105320953fast_ed
faster94625773faster_
gabbard1336553gabbard
gasted84821583gast_ed
gaster75027353gaster_
gasters85624293gasters
gastral8329553gastral
haftara13136093haftara
haggard13377183haggard
halyard1476973halyard
hastate10313913hastate
hasted105125283hast_ed
hayward1736413hayward
hazard1938403ha_zard
instar6310013instar_
instars7411133instars
kantar10311153kantar_
kantars11310033kantars
lactary1237853lactary
laggard10347623laggard
laniard868523laniard
lanyard1167293lanyard
lascar868573lascar_
lascars979013lascars
lasted74323603last_ed
laster64830633laster_
lasters75627693lasters
leotard846193leotard
mallard10310273mallard
mansard1049313mansard
manward1349093manward
mascara1138023mascara
mastaba1146223mastaba
masted94025803mast_ed
master84831343master_
mastered112614003mastered
masters94628923masters
mastery124214323mastery
mastoid10711233mastoid
mazard1838763ma_zard
mazzard1844463mazzard
mustards11297883mustards
mustardy14265053mustardy
pasta76624533pasta__
pastas85422873pasta_s
pasted94426903past_ed
paster85734373paster_
pastern94415063pastern
pasters94531733pasters
pastor84817483pastor_
pastored1139973pastored
pastors94119003pastors
pastry114913033past_ry
pasture9311463pasture
pastured1138233pastured
petard95013803_petard
postcard1346523postcard
raster64731443raster_
rasters74629023rasters
restart7320033restart
retard75018933_retard
ritard74812083_ritard
saggard10358953saggard
sard55344243__s_ard
satara6315533sa_tara
shard96125963__shard
staid66722083__staid
stand65923283__stand
star48037763__star_
stare54440263__stare
stared75429873__stared
stark95425623__stark
stars55836573__stars
start55642313__start
sward94221463__sward
tabard9313333ta_bard
tankard1267263tankard
tantara72410823tantara
tanyard1167183tanyard
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
tasted74123973tast_ed
taster64930573taster_
tasters74225643tasters
tatar56122063ta_tar_
tatars64619793ta_tars
unitard838003unitard
upstand1045343upstand
upstare9158683upstare
upstared11156573upstared
upstart9159753upstart
vanward1456943vanward
vaster94521023vaster_
vaward13498723va_ward
visard103910123vis_ard
vistaed1138023vistaed
wastage11109253wastage
wasted104423023wast_ed
waster95228943waster_
wasters104026593wasters
wastery134610993wastery
wastry12388773wast_ry
wayward1736053wayward
westward1543823westward

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.406440125.6
2DLD Change Limit1340272197.09618887.7
3Display Results2192190.0762881.6
 (SQL Overall)1786912197.57823580.2
 
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.