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

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

70 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
groundbreakers2212113(None) 
groundbreaker21121131groundbreaker_
groundbreaking237693groundbreaking
groundskeepers2211894groundskeepers
groundwaters1751464ground__waters
housebreakers2262134_housebreakers
windbreakers2261654__windbreakers
grounders1156785ground_____ers
groundsheets1761515groundshe__ets
groundskeeper2110885groundskeeper_
groundwater1651535ground__water_
grubstakers1851475gr_u__bstakers
housebreaker2162435_housebreaker_
loudspeakers1961045_lou_dspeakers
trailbreakers1961475tr_ailbreakers
troublemakers21121615trou__blemakers
undertakers1643815___undertakers
windbreaker2151795__windbreaker_
backbreakers21142056__backbreakers
breakers143810976______breakers
crossbearers1651606cro_ssb_earers
drumbeaters1651846dr_u_mb_eaters
greenbackers2152026green_b_ackers
greenbriers1452266green_br__iers
grosbeaks1642086gro__sb_eak__s
groundburst1551746groundb____urst
groundbursts1661096groundb__ursts
grounder1047616ground_____er_
groundfishes2051616ground_fishe_s
groundless1243476ground____less
groundlessness16102596groundlessness
groundmass1451936ground__ma__ss
groundmasses1651386ground__masses
groundsels1242386ground____sels
groundsheet1662246groundshe__e_t
groundswells176996groundswe__lls
groundworks2052096ground_work__s
grubstaker1751546gr_u__bstaker_
grubstakes1771746gr_u__bstake_s
heartbreakers2261456_heartbreakers
housebreaks2052576_housebreak__s
icebreakers1952196___icebreakers
ironworkers1852066iro_nwor__kers
jawbreakers2761746___jawbreakers
lawbreakers2062076___lawbreakers
loudspeaker1861166_lou_dspeaker_
mouthbreeders2112826_mouthbreeders
nonbreeders1472386_no_n_breeders
nondrinkers1652876_no_nd_rinkers
nonreaders1145436_no_n__readers
nonspeakers17113116_no_n_speakers
outbreaks1544076__ou_tbreak__s
poundcakes19102136_pound__cake_s
proofreaders185796pro__ofreaders
roundballs1352766_roundb__a_lls
roundedness1354296_round__edness
rounders92613696_round_____ers
roundheaded1752166_round_heade_d
roundheels1452026_round_he__els
roundnesses1247046_round_nesse_s
strikebreakers1981176strikebreakers
tiebreakers1752566___tiebreakers
trailbreaker1861606tr_ailbreaker_
trainbearers1451736train_b_earers
troublemaker20121656trou__blemaker_
unbrakes14258416___un_br_ake_s
underbakes1746366___underbake_s
undertaker1545786___undertaker_
undertakes1547696___undertake_s
windbreaks2052026__windbreak__s

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790709.33013375.1
3Display Results70700.0302333.3
 (SQL Overall)178691709.50018809.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.