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

76 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
bregmate134553(None) 
bregmata1343201bregmata
bedmate1239432b_edmate
bregma1134962bregma__
bregmatic1644062bregmatic
bromate11313552br_omate
cremate113816182cre_mate
crewmate15405632crewmate
regmata1036192_regmata
regrate82618662_regrate
remate84428682_re_mate
ablegate1147253ableg_ate
abnegate1144863abneg_ate
abrogate11129603abrog_ate
agemate101210583age_mate
areolate81014453areolate
bandmate1347973bandmate
bedmates1349183b_edmates
begat86629723b_eg_at_
begaze1838333b_eg_aze
bemata10411693b_e_mata
berate84729023b_e_rate
boehmite1583153boehmite
breakage1544183breakage
breath113916263bre__ath
breathe123711843bre__athe
brecciate1544173brecciate
brewage1347183bre_wage
brigade1136493brig_ade
bromated1339173br_omated
bromates12413143br_omates
bunkmate1643963bunkmate
create85126383cre__ate
cremated133412963cre_mated
cremates124216003cre_mates
crenate93317113cre_nate
crewmates16375803crewmates
eremite9312833ere_mite
ergate7315143er_g_ate
fermate122813003_fermate
frigate11311063frig_ate
gemmate12418383_gemmate
legate72917453_leg_ate
negate72915573_neg_ate
predate10616893pre_date
pregame1239553preg_ame
prelate9519693pre_late
premade12311443pre_made
primate111516283pr_imate
ramate83921683_r_amate
rebate84424113_re_bate
recrate92621663_recrate
redate74124683_re_date
reflate103516263_reflate
regale74821453_reg_ale
regave104713383_reg_ave
regelate9312083_regelate
reggae858953_regga_e
reglaze1747223_reglaze
regma84612333_regma__
regrade92612033_regrade
regrated102816333_regrated
regrates92618403_regrates
regulate9313023_regulate
reimage1037913_reimage
relate64033633_re_late
remade94316983_re_made
remake124016113_re_make
remated103522473_re_mated
remates93827113_re_mates
remote84222603_re_mote
replate93420053_replate
reslate73520593_reslate
restate73824883_restate
rugate75813813_rug_ate
sigmate10710143_sigmate

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 Limit146162766.51622431.2
3Display Results76760.0302533.3
 (SQL Overall)178691766.96925640.8
 
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.