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

52 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
breastfed154269(None) 
breasted1138821breast_ed
breastfeed1651461breastfeed
breastfeeds175802breastfeeds
breathed14469642brea_thed
abreacted1444293abreact_ed
basted95227233b__ast_ed
beastie92412433b_eastie_
beasties102514653b_easties
berated104422133bera_t_ed
bested94922763b_e_st_ed
blasted104213473b_last_ed
bleated104015973blea_t_ed
boasted104113743b_oast_ed
bracted12410933br_act_ed
brassed103612373br_as_sed
brattled11196723br_attled
breached163411643brea_ched
breaded115014063brea__ded
breamed124011593brea__med
breast8319633breast___
breasting1239583breasting
breastpin1342593breastpin
breasts939703breast__s
breathe123711843brea_the_
breather133610593brea_ther
breathes134212903brea_thes
breveted1435623brevet_ed
brevetted1543863brevetted
bristled11187343br_istled
creased104315583creas__ed
created104323453crea_t_ed
crested103416533cre_st_ed
feasted11310843_feast_ed
greased93812393greas__ed
preacted132710943preact_ed
prepasted14137673prepast_ed
pretasted12147963pretast_ed
reacted103015713_react_ed
reasoned9410733_reasoned
reested82916233_reest_ed
repasted112611533_repast_ed
rested74430783_re_st_ed
retasted92412113_retast_ed
roasted83912663_roast_ed
treasured1044983treasured
treated83618703trea_t_ed
wrastled12346433wr_astled
wreathed15257463wrea_thed
wrested113410933wre_st_ed
wrestled12296763wre_stled
yeasted1138503_yeast_ed

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit148641527.68619339.2
3Display Results52520.0163250.0
 (SQL Overall)178691528.12521992.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.