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

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

74 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
grayfish184448(None) 
crayfish1944251crayfish
grayish1437811gray_ish
crawfish1944232crawfish
draffish1844552draffish
garfish14179202g_arfish
giraffish1941972giraffish
goatfish1544292goatfish
grayfishes2043632grayfishes
greyish1435172grey_ish
gruffish1843942gruffish
raffish1658842_raffish
ratfish1338772_ratfish
batfish1558683_batfish
boarfish1635753boarfish
brackish1987613brackish
brainish1338813brainish
brandish1469023brandish
brassish1346433brassish
brattish1346973brattish
catfish1559023_catfish
clayish1547943clay_ish
coalfish1635493coalfish
crampfish2142593crampfish
crankish1736513crankish
crayfishes2143403crayfishes
deafish1438533dea_fish
dealfish1545503dealfish
drumfish1743503drumfish
dryish1336323dr_y_ish
dwarfish1843783dwarfish
flatfish1744933flatfish
frogfish1843943frogfish
garish104516923g_a_rish
garnish111610843g_arnish
gawkish1835833g_awkish
goatish1139563goa_tish
goldfish1644203goldfish
goyish13379013g_oy_ish
graffiti1542983graffiti
graffito1542873graffito
grafts105013253gra_fts_
gratis74819243gra_tis_
grayest11489363gray_est
graying124115883gray_ing
grayling1338003grayling
grayness1235933grayness
grays95621333gray__s_
greenish1247083greenish
grumpish1643763grumpish
hagfish17227613_hagfish
headfish1845443headfish
ladyfish1843803ladyfish
oafish121311723_oa_fish
oarfish13158613_oarfish
orangish1246553orangish
panfish15229973_panfish
platyfish2042683platyfish
prankish1737023prankish
radish103516913_ra_dish
rakish134313963_ra_kish
rammish1437563_rammish
rankish14510383_rankish
raspish1298103_raspish
rattish10510823_rattish
ravish123414033_ra_vish
rawish123012913_ra_wish
redfish1437793_redfish
sawfish1637683_sawfish
starfish1438083starfish
toadfish1544903toadfish
trampish1535653trampish
waifish1637703_waifish
weakfish2143523weakfish

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 Filter1786911461620.420425454.8
2DLD Change Limit146162747.79618748.3
3Display Results74740.0332242.4
 (SQL Overall)178691748.24921662.1
 
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.