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

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

74 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
breast831963(None) 
abreast9311271abreast
beast76338641b_east
breasts939701breasts
abreact11310822abreact
areas55935772areas_
barest85327692bare_st
bast66362412b__ast
beasts84519722b_easts
beat66168302b_ea_t
beats76042242b_eats
beaut75135212b_eaut
best66355322b_e_st
blast76532572b_last
bleat75737002blea_t
bleats85518612bleats
blest76431722ble_st
boast75935702b_oast
boreas85421732boreas_
bract96332722br_act
braes75735052braes_
brant74742172br_ant
bras65746452br_as_
brash106221562br_ash
brass75428022br_ass
brat66055542br_a_t
brats75336012br_ats
breach134213722breach
bread85523112brea_d
breads95419202breads
breadth1365992breadth
bready124511182bready
break115319402brea_k
breaks124816422breaks
bream95121812brea_m
breams104815042breams
breasted1138822breasted
breath113916262breath
brees75632552brees_
brens75823362brens_
brent75734132bre_nt
brents84717272brents
brevet115717332brevet
brews105617072brews_
bypast13117372bypast
crease85519572crease
creasy114612302creasy
crest74632692cre_st
dreamt94615712dreamt
drest65530342dre_st
east46659102__east
feast85932722_feast
freest95318282freest
grease75416232grease
greasy10419462greasy
great66034242grea_t
greats76318392greats
least56134882_least
preact103220392preact
precast11314852precast
prest75736352pre_st
react74634332_react
recast83422772_recast
reest54938092_reest
repast83520632_repast
resat55139682_resat
rest46459842_re_st
roast56230142_roast
treat56240352trea_t
treats64821692treats
ureas55826012ureas_
urease64516992urease
wrest84925432wre_st
yeast85327942_yeast

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551742.50033020.4
3Display Results74740.0302466.7
 (SQL Overall)178691742.87362196.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.