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

115 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
brackish198761(None) 
blackish1976711blackish
blackfish2343832blackfish
blockish19115792blockish
brainish1338812brainish
brandish1469022brandish
brassish1346432brassish
brattish1346972brattish
buckish18237882b_uckish
crankish1736512crankish
prankish1737022prankish
quackish2654382quackish
rakish134313962_ra_kish
rankish14510382_rankish
trickish1746792trickish
babyish1736513b_abyish
backing165523443b_acking
backlash1945923b_acklash
backlist16910653b_acklist
backrush1944103b_ackrush
backs135729623b_ack_s_
backwash2244943b_ackwash
baldish1339503b_aldish
banish111416043b_a_nish
batfish1558683b_atfish
beamish14259293bea_mish
bearish123013273bea_rish
beauish12268513bea_uish
blackest16269303blackest
blacking174213603blacking
blacklist1746123blacklist
blacks144914953black_s_
blandish1497003blandish
bleakish1745053bleakish
boarfish1635753boarfish
boarish123911913boa_rish
bookish163610023b_ookish
bracers114616703bracers_
braces108427773brac_es_
brach126123303brac___h
braches144621223braches_
brachia141910423brachi_a
brachial15219303brachial
brachium1766113brachium
brachs134415753brac_hs_
bracing123817613brac_ing
bracken15409813brack_en
brackens16327923brackens
bracket154117233brack_et
brackets163310433brackets
bracts105617773brac_ts_
braise84318753bra__ise
brakes124923123bra_kes_
brakier133812363bra_kier
brakiest143912243bra_kiest
braking143917713bra_king
branks124817383brank_s_
brash106221563bra___sh
brickier16307163brickier
brickiest1737433brickiest
bricking173911403bricking
bricks144614623brick_s_
brinish1239963br_inish
broadish1446933broadish
brocks145214153brock_s_
broguish1444103broguish
brownish1645643brownish
brutish1237703br_utish
cockish1838503_cockish
cracking174013903cracking
cracks144817003crack_s_
crawfish1944233crawfish
crayfish1944253crayfish
darkish1537943_darkish
draffish1844553draffish
freakish1845543freakish
gawkish1835833_gawkish
grayfish1844483grayfish
grayish1437813gra_yish
hawkish2036553_hawkish
hickish1936473_hickish
jackfish2744123_jackfish
larkish1439083_larkish
mawkish1935823_mawkish
orangish1246553orangish
peakish16268873pea_kish
peckish18227293_peckish
practise12310143practise
puckish18237213_puckish
quackism2543513quackism
rachis114017653_rachis_
racism103214193_rac_ism
racist82822793_rac_ist
racking144323663_racking
racks115028853_rack_s_
radish103516913_ra_dish
raffish1658843_raffish
rakis95323443_ra_kis_
rammish1437563_rammish
raspish1298103_raspish
ratfish1338773_ratfish
rattish10510823_rattish
ravish123414033_ra_vish
rawish123012913_ra_wish
rockfish2043903_rockfish
sickish1638423_sickish
sparkish17276973sparkish
stockish17186043stockish
thickish2044603thickish
tracking153715463tracking
tracks124818843track_s_
trampish1535653trampish
weakish17217173wea_kish
wracking18349963wracking
wracks154711113wrack_s_

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.406440125.6
2DLD Change Limit1461621156.40622816.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.85826055.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.