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

140 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
dastards1027808(None) 
bastards113310311bastards
dastard9279701dastard_
bastard103012422bastard_
bastardy14326002bastardy
bustards11308512bustards
costards113510792costards
custards11338392custards
dastardly14273802dastardly
daystars1243902daystar_s
discards1238912discards
dotards937252d_otards
eastwards1344252eastwards
mustards11297882mustards
altars64518153_altar_s
ascarids11438503_ascarids
ascaris93613323_ascaris
asters65631603_aster_s
astrals75515243_astrals
attars64515313_attar_s
awards107113453_a_wards
bastardies1365143bastardies
bastardise1383563bastardise
bastardly15264293bastardly
basters94930303baster_s
bayards13379683ba_yards
brassards1244063brassards
bustard10389723bustard_
cabstands1453733cabstands
canards10311203ca_nards
cascaras1237703cascaras
casters94729903caster_s
castors94919443castor_s
coastwards1643063coastwards
costard104113353costard_
costars94218013costar_s
custard10389973custard_
custardy14314903custardy
dabsters1137053dabster_s
damars93814993da_mar_s
dammars12308193dammar_s
darbars10510093darbar_s
dartboards1443883dartboards
darters84017603darter_s
dashboards1743483dashboards
dashers115016863dasher_s
dasyures1254153dasyures
dataries9314033da_taries
datary10310243da_tar_y
daters74827373da_ter_s
daturas838773da_turas
daycares1454803daycares
daymares1445333daymares
daystar1143443daystar__
debeards1235503debeards
desands94810163des_ands
destains9311813destains
diastases1047073diastases
diasters92913183diaster_s
diehards1346213diehards
disarms1039043dis_arms
disbands1237353disbands
disbars10310323disbar_s
discard11310213discard_
discords1238593discords
disparts11109953disparts
distaffs1565083distaffs
distains9413603distains
distaves12311403distaves
distends10339823distends
distorts91112353distorts
disturbs1145403disturbs
dotard839053d_otard_
dullards1045493dullards
dusters84918363duster_s
dustrags1044943dustrags
easters75125683easter_s
eastward1244993eastward_
gabbards1445753gabbards
gasters85624293gaster_s
haftaras14136073haftaras
haggards14366763haggards
halyards1576243halyards
haywards1845873haywards
hazards2037463ha_zards
instars7411133instar_s
kantars11310033kantar_s
laggards11307053laggards
laniards967313laniards
lanyards1266393lanyards
lascars979013lascar_s
lasters75627693laster_s
leotards945303leotards
mallards1138323mallards
mansards1148013mansards
manwards1447613manwards
mascaras1237693mascaras
mastabas1246803mastabas
masters94628923master_s
mastoids1177873mastoids
mazards1937703ma_zards
mazzards1943943mazzards
mustard10359533mustard_
mustardy14265053mustardy
pastas85422873pasta__s
pasterns104112623pasterns
pasters94531733paster_s
pastors94119003pastor_s
pastures10311963pastures
petards104311153_petards
postcards1445733postcards
rasters74629023raster_s
restarts8310873restarts
retards85015003_retards
ritards8439943_ritards
saggards11397493saggards
sards64736183__s_ards
sataras7315063sa_taras
shards104319173__shards
stands75118053__stands
stares66038753__stares
stars55836573__star_s
starts65423123__starts
swards105415133__swards
tabards10310383ta_bards
tankards1366253tankards
tantaras8269543tantaras
tanyards1276183tanyards
tartars73313403tartar_s
tasters74225643taster_s
tatars64619793ta_tar_s
unitards945623unitards
upstands1144093upstands
upstares10178583upstares
upstarts10165273upstarts
vawards14457573va_wards
visards11328153vis_ards
wastages12109753wastages
wasters104026593waster_s
westwards1643393westwards

Search took 10 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 Filter1786911461620.780229091.0
2DLD Change Limit1461621408.86016496.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911409.68618448.4
 
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.