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

166 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
bastards11331031(None) 
bastard103012421bastard_
bastardy14326001bastardy
bustards11308511bustards
dastards10278081dastards
bastardies1365142bastardies
bastardise1383562bastardise
bastardly15264292bastardly
basters94930302baster_s
bayards13379682ba_yards
brassards1244062brassards
bustard10389722bustard_
costards113510792costards
custards11338392custards
dastard9279702dastard_
eastwards1344252eastwards
mustards11297882mustards
abstains1047323abstains
absurds1035003abs_urds
altars64518153_altar_s
ascarids11438503_ascarids
ascaris93613323_ascaris
asters65631603_aster_s
astrals75515243_astrals
attars64515313_attar_s
awards107113453_a_wards
baccaras1446913baccaras
backwards2147463backwards
backyards2146533backyards
badlands1236673badlands
baiters94619303baiter_s
ballads104212913balla_ds
ballyards1544993ballyards
bandstands1443113bandstands
bankcards1873783bankcards
bantams1149063banta_ms
banters94623113banter_s
bards87139643b___ards
barmaids1345943barmaids
barnyards1543493barnyards
bartends1136793bartends
barters94223033barter_s
barwares13610093barwares
basalts9358963bas_alts
baseboards1545213baseboards
bashaws15347713basha_ws
bashers124820833basher_s
basmatis1247343basmatis
bastardised1572283bastardised
bastardises1473483bastardises
bastardize2263093bastardize
bastardizes2392863bastardizes
basted95227233bast_ed_
baster85333593baster__
bastes85330383bast__es
bastiles10313353bastiles
bastings114214693bastings
bastions10411693bastions
basts75936933bast___s
batters94626013batter_s
bayard124411663ba_yard_
bazaars18275883bazaar_s
bazars174613113ba_zar_s
beards94116673b__eards
bedstands1343503bedstands
bedwards1596393bedwards
beeyards1444593beeyards
besteads11307123besteads
bestirs9311133bestir_s
bestuds10326753best_uds
beswarms1544323beswarms
bisters93922613bister_s
bistorts10118813bistorts
bistres94017213bist_res
bistros92810983bist_ros
blasters104116143blaster_s
boards94616933b__oards
boasters103915663boaster_s
boatyards1543963boatyards
bollards11339153bollards
bombards1536493bombards
boyards13399323b_oyards
brassard1144683brassard_
brassarts1143823brassarts
briards10398553b_riards
busbars1138153busbar_s
busters94724133buster_s
buzzards1943613buzzards
cabstands1453733cabstands
canards10311203ca_nards
cascaras1237703cascaras
casters94729903caster_s
castors94919443castor_s
coastwards1643063coastwards
costard104113353costard_
costars94218013costar_s
custard10389973custard_
custardy14314903custardy
dastardly14273803dastardly
daystars1243903daystar_s
discards1238913discards
dotards937253_dotards
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 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621666.56322270.6
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.04625360.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.