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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 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
daystars124390(None) 
daystar1143441daystar_
dabsters1137052dabsters
dastard9279702da_stard
dastards10278082da_stards
altars64518153_a_ltars
asters65631603_a_sters
attars64515313_a_ttars
avatars1036443_avatars
bastard103012423ba_stard
bastards113310313ba_stards
basters94930303ba_sters
caesars9410733caes_ars
capstans1257243capstans
casters94729903ca_sters
castors94919443ca_stors
clysters13227843clysters
costars94218013_costars
crystals1347173crystals
dabster1036703dabster_
damars93814993da__mars
dammars12308193da_mmars
danseurs933433danseurs
darbars10510093da_rbars
darshans1286543darshans
darters84017603da_rters
dashers115016863da_shers
datary10310243da__tary
daters74827373da__ters
daunters9329853daunters
daycare1355093day_care
daycares1454803day_cares
daymare1375633day_mare
daymares1445333day_mares
daysides1335963daysides
daysman1335053daysma_n
diasters92913183diasters
diesters92513603diesters
disbars10310323d_isbars
dragsters1134323dragsters
dusters84918363d_usters
easters75125683ea_sters
gagsters10317083gagsters
gasters85624293ga_sters
gaydars1235803gay_dars
hamsters13710423hamsters
haystack2044013haystack
haystacks2143373haystacks
instars7411133_instars
kantars11310033ka_ntars
keysters15326333keysters
lamsters1099753lamsters
lascars979013la_scars
lasters75627693la_sters
loadstars1043313loadstars
masters94628923ma_sters
naysays1344123nays_ays
oysters103411693_oysters
pastas85422873pa_sta_s
pasters94531733pa_sters
pastors94119003pa_stors
rasters74629023ra_sters
roysters113610533roysters
sansars73313913sans_ars
sarsars73512143sars_ars
shysters14106463shysters
stars55836573___stars
tapsters10318803tapsters
tartars73313403ta_rtars
tasters74225643ta_sters
tatars64619793ta__tars
trysters11298373trysters
waisters113811523waisters
wasters104026593wa_sters
xysters17307163_xysters

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 Filter1786911461620.423422437.4
2DLD Change Limit146162756.29623215.1
3Display Results75750.0302500.0
 (SQL Overall)178691756.74926476.7
 
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.