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

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

81 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
blindfishes205258(None) 
blandishes1644612bland_ishes
blindfish1842762blindfish__
clingfishes2052542clingfishes
baitfishes1844053bai_tfishes
billfishes1844253b_illfishes
blackfishes2543503blackfishes
blandished1743333bland_ished
blandisher1643463bland_isher
blandishers1743003bland_ishers
blindnesses1446183blindnesses
blindsides1442373blindsi_des
blowfishes2143463bl_owfishes
bluefishes1844313bl_uefishes
bonefishes1844913b_onefishes
brandishes1645893brand_ishes
finfishes1846043_fin_fishes
kingfishes2143703_kingfishes
lionfishes1643543_lionfishes
lungfishes1743413_lungfishes
pinfishes1746243_pin_fishes
sandfishes1745543_sandfishes
banishes131812464b_an__ishes
batfishes1746584b__atfishes
blandish1497004bland_ish__
blandnesses1446624blandnesses
blemishes1665084bl__emishes
blindages1343664blind__ages
blindfolded195834blindfolded
blindfolds1751324blindf_olds
blindness1235344blindnes__s
blindside1342754blindsi_de_
blindsided1551524blindsi_ded
blondines1246154blond_i_nes
blondish1476174blond_ish__
blondnesses1445544blondnesses
boarfishes1844974b_oarfishes
boxfishes2444154b__oxfishes
brandished1744004brand_ished
burnishes1436644burn__ishes
clingfish1842984clingfish__
codfishes1845644__codfishes
filefishes1944484_filefishes
finishes1438984_fin__ishes
flatfishes1943994fl_atfishes
globefishes2052314globefishes
goldfishes1863564_goldfishes
groundfishes2051614groundfishes
headfishes2044414_headfishes
killifishes2152044killifishes
kingfisher2152244_kingfisher
kingfishers2251714_kingfishers
ladyfishes2052844_ladyfishes
languishes1444244_languishes
lindies8416584_lind_i__es
lumpfishes2042874_lumpfishes
milkfishes2243124_milkfishes
minishes13310584_min__ishes
monkfishes2243744_monkfishes
moonfishes1844194moon_fishes
mudfishes1844194__mudfishes
panfishes1737594_pan_fishes
pigfishes1845004_pi_gfishes
pilotfishes1962134pilotfishes
pipefishes2043794_pipefishes
planishes14138524plan__ishes
platyfishes2252194platyfishes
plenishes1487084plen__ishes
redfishes1645794__redfishes
relinquishes2451994relinquishes
sailfishes1644644sai_lfishes
standishes1445714stand_ishes
stonefishes1753714stonefishes
studfishes17103794_studfishes
sunfishes1547034_sun_fishes
swordfishes2152164swordfishes
tilefishes1644604_tilefishes
toadfishes1743794_toadfishes
trunkfishes2151774trunkfishes
tundishes1344544_tund_ishes
whitefishes2352644whitefishes

Search took 9 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.1731032896.0
2DLD Change Limit148819817.87618895.3
3Display Results81810.0461760.9
 (SQL Overall)178691818.09522074.2
 
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.