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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
brandish146902(None) 
blandish1497001blandish
baldish1339502b_aldish
banish111416042b_an_ish
blondish1476172blondish
brackish1987612brackish
brainish1338812brainish
brandied1259112brandied
brandies11714562brandies
branding122513682branding
brandished1744002brandished
brandishes1645892brandishes
brands95118942brand_s_
brassish1346432brassish
brattish1346972brattish
brinish1239962brin_ish
broadish1446932broadish
crankish1736512crankish
orangish1246542orangish
prankish1737022prankish
radish103516912_ra_dish
rankish14510382_rankish
standish1238542standish
babyish1736513b_abyish
bandas95120543b_andas_
bandied114414303b_andied
bandies104124863b_andies
banding114921413b_anding
bandit93821133b_andi_t
bandito103710043b_andito
bandits103814793b_andits
bands85233423b_and_s_
batfish1558683b_atfish
beamish14259293bea_mish
bearish123013273bea_rish
beauish12268513bea_uish
bindis94614583b_indis_
blackish1976713blackish
blandest113811043blandest
blandished1743333blandished
blandisher1643463blandisher
blandishes1644613blandishes
blindfish1842763blindfish
boarfish1635753boarfish
boarish123911913boa_rish
bradding13268933bradding
brads85528293bra_d_s_
braiding123112703braiding
braids95015683braid_s_
brainwash1742663brainwash
braise84318753bra__ise
branch134014773bran__ch
brand85124493brand___
branded114414103brand_ed
brander103915823brand_er
branders114313093branders
brandings13277483brandings
brandishing1853353brandishing
brandless1236123brandless
brandling1348253brandling
brandy124712063brand__y
brandying1654883brandying
branks124817383bran_ks_
brannier10218933brannier
branniest11199383branniest
branning112911093branning
brans75437433bran__s_
brants85723053bran_ts_
brash106221563bra___sh
broguish1444103broguish
brownish1645643brownish
brutish1237703br_utish
bundist10310193b_undist
burnish1238623burn_ish
caddish143810123_caddish
clannish1345263clannish
crawfish1944233crawfish
crayfish1944253crayfish
cronish12310863cron_ish
dandyish1644723_dandyish
danish101513793_dan_ish
draffish1844553draffish
dronish1138913dron_ish
evanish1337653evan_ish
faddish15359003_faddish
fiendish1544033fiendish
garnish111610843garn_ish
grandest10311573grandest
grandiose1145793grandiose
grandioso1143913grandioso
grands84218243grand_s_
grandsir1044313grandsir
grayfish1844483grayfish
grayish1437813gra_yish
jadish17319903_ja_dish
kaddish16317973_kaddish
laddish12299723_laddish
maddish14289483_maddish
maidish13239553_maidish
mannish121710693_mannish
panfish15229973_panfish
planish12412053plan_ish
prandial1149643prandial
prudish1376563pr_udish
raffish1658843_raffish
rakish134313963_ra_kish
rammish1437563_rammish
randier83618473_randier
randies84225663_randies
randiest93418773_randiest
rands65930453_rand_s_
ranids75118703_ranids_
ranis55235833_ran_is_
raspish1298103_raspish
ratfish1338773_ratfish
rattish10510823_rattish
ravish123414033_ra_vish
rawish123012913_ra_wish
reddish1238033_reddish
roundish1246253roundish
runtish1048693_runtish
sandfish1556683_sandfish
tannish101610573_tannish
tarnish101611873tarn_ish
toadish1139063toa_dish
trampish1535643trampish
tundish1137283_tundish
uranism91112513uran_ism
vanish121513203_van_ish
varnish13169533varn_ish
zanyish2235903_zanyish

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.1561145455.1
2DLD Change Limit1461621316.40622816.4
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.60827041.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.