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

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

111 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
blackfishes254350(None) 
blackfish2343832blackfish__
jackfishes2943762_jackfishes
backfires2046173b_ackfi_res
backlashes21125303b_acklashes
backrushes2143773b_ackrushes
backwashes24104673b_ackwashes
baitfishes1844053b_aitfishes
batfishes1746583b_a_tfishes
blackfaces2343563blackf_aces
blackfins2054393blackfi__ns
blackflies2143733blackf_lies
blackish1976713black_ish__
blacklisted2052513blacklisted
blacklister1952263blacklister
blacklisters2051743blacklisters
blacklists1844183blacklis_ts
blacknesses1944993blacknesses
blandishes1644613bla_ndishes
blindfishes2052583blindfishes
blowfishes2143463bl_owfishes
bluefishes1844313bl_uefishes
boarfishes1844973boa_rfishes
flatfishes1943993fla_tfishes
ladyfishes2052843_ladyfishes
platyfishes2252193platyfishes
rockfishes2263513_rockfishes
stockfishes2352883stockfishes
suckfishes2243433_suckfishes
weakfishes2343353wea_kfishes
backaches22146814b_ack_aches
backbites19108634b_ackbi_tes
backfields2252214b_ackfields
backfilled2253224b_ackfilled
backfills20104654b_ackfi_lls
backfire1946004b_ackfi_re_
backfired2144544b_ackfi_red
backfits19106954b_ackfi__ts
backfitted2253254b_ackfitted
backlashed22124284b_acklashed
backlasher21124484b_acklasher
backlashers22123634b_acklashers
backlights2253994b_acklights
backlisted1944504b_acklisted
backlists17117414b_acklis_ts
backsides1887694b_acksi_des
backslashes2253444b_ackslashes
backwashed25123764b_ackwashed
bakshishes2242004b_akshishes
banishes131812464b_a__nishes
billfishes1844254b_illfishes
blackbirded2351794blackbirded
blackbirder2251914blackbirder
blackbirders2351504blackbirders
blackbirds2143254blackbi_rds
blackbodies2252494blackbodies
blackface2243424blackf_ace_
blackfin1953904blackfi___n
blackings18316764black_i_ngs
blacklist1746124blacklis__t
blackness1735664blacknes__s
blacksmiths2472144blacksmith_s
blacksnakes1852534blacksnakes
blandished1743334bla_ndished
blandisher1643464bla_ndisher
blandishers1743004bla_ndishers
blanknesses1744934blanknesses
blemishes1665084bl__emishes
blockish19115794block_ish__
bonefishes1844914b_onefishes
boxfishes2444154b__oxfishes
brackish1987614brack_ish__
brackishness2352454brack_ishness
brandishes1645894bra_ndishes
catfishes1746304_ca_tfishes
cavefishes2143864_cavefishes
clingfishes2052544clingfishes
coalfishes1844694coa_lfishes
crampfishes2352264crampfishes
crawfishes2143594cra_wfishes
crayfishes2143404cra_yfishes
dealfishes1744194dea_lfishes
fallfishes1943984_fallfishes
garfishes16167084_ga_rfishes
glacises1138504glac__is_es
globefishes2052314globefishes
goatfishes1743934goa_tfishes
grayfishes2043634gra_yfishes
hagfishes1945154_ha_gfishes
headfishes2044414hea_dfishes
jackfish2744124_jackfish__
languishes1444244_languishes
lavishes1457404_la__vishes
lionfishes1643544_lionfishes
lumpfishes2042874_lumpfishes
lungfishes1743414_lungfishes
milkfishes2243124_milkfishes
monkfishes2243744_monkfishes
oarfishes15156954_oa_rfishes
panfishes1737594_pa_nfishes
planishes14138524pla__nishes
ratfishes1546104_ra_tfishes
sailfishes1644644_sailfishes
sandfishes1745544_sandfishes
sawfishes1845744_sa_wfishes
slacknesses1745244slacknesses
snakefishes2152414snakefishes
spadefishes2052694spadefishes
starfishes1646154sta_rfishes
toadfishes1743794toa_dfishes
trunkfishes2151774trunkfishes

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191119.06316420.5
3Display Results1111110.0631761.9
 (SQL Overall)1786911119.54618718.9
 
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.