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

55 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
goosefishes185229(None) 
globefishes2052312globefishes
goosefish1642272goosefish__
goosefleshes196802goosefleshes
rosefishes1644112_rosefishes
bonefishes1844913_bonefishes
foolfishes1943763foo_lfishes
frostfishes2052273frostfishes
goatfishes1743943g_oatfishes
goldfishes1863563g_oldfishes
moonfishes1844193moo_nfishes
stonefishes1753713stonefishes
blowfishes2143464blo_wfishes
bluefishes1844314_bluefishes
boarfishes1844974_boarfishes
boxfishes2444154_bo_xfishes
cavefishes2143864_cavefishes
closefisted17101174closefisted
coalfishes1844694_coalfishes
codfishes1845644_co_dfishes
cowfishes2045724_co_wfishes
damselfishes2151244damselfishes
dogfishes1745084_do_gfishes
filefishes1944484_filefishes
foxfishes2544054_fo_xfishes
frogfishes2043324fro_gfishes
garfishes16167084g__arfishes
gibberishes1951724gibberishes
globefish1842474globefish__
gooseflesh1751004goosef__lesh
goosefoots1451714goosef_oots
goosegrasses1461104goosegrasses
grayfishes2043634g_rayfishes
groundfishes2051614groundfishes
hogfishes1944684_ho_gfishes
horsefleshes2151334horsefleshes
lionfishes1643544lio_nfishes
loosenesses1147244loosenesses
monkfishes2243744_monkfishes
oarfishes15156954__oarfishes
outfishes15118024__outfishes
overfishes1947014_overfishes
pipefishes2043794_pipefishes
rockfishes2263514_rockfishes
rosebushes1572254_rosebushes
rosefish1445264_rosefish__
sablefishes1952894sablefishes
snakefishes2152414snakefishes
spadefishes2052694spadefishes
stockfishes2352884stockfishes
swordfishes2152164swordfishes
tilefishes1644604_tilefishes
toadfishes1743794_toadfishes
whitefishes2352644whitefishes
wolffishes2242984_wolffishes

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.436409841.7
2DLD Change Limit148819558.03018532.9
3Display Results55550.0331666.7
 (SQL Overall)178691558.49921024.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.