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

75 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
crayfish194425(None) 
crawfish1944231crawfish
grayfish1844481grayfish
catfish1559022c_atfish
clayish1547942clay_ish
coalfish1635492coalfish
crampfish2142592crampfish
crankish1736512crankish
crayfishes2143402crayfishes
draffish1844552draffish
grayish1437812gray_ish
raffish1658842_raffish
ratfish1338772_ratfish
batfish1558683_batfish
boarfish1635753boarfish
brackish1987613brackish
brainish1338813brainish
brandish1469023brandish
brassish1346433brassish
brattish1346973brattish
caddish143810123c_addish
carlish12312763c_arlish
cattish12410723c_attish
cavefish1974853cavefish
clannish1345263clannish
codfish1637163c_odfish
cowfish1836433c_owfish
coyish143710393c_oy_ish
crabwise1543613crabwise
crafts115312743cra_fts_
cramoisy1543703cramoisy
crash109120013cra___sh
crasis85020473cra_sis_
crawfished2242253crawfished
crawfishes2143593crawfishes
crayonist1446243crayonist
crayons12439233crayons_
cronish12310863cr_onish
deafish1438533dea_fish
dealfish1545503dealfish
drumfish1743503drumfish
dryish1336323dr_y_ish
dwarfish1843783dwarfish
flatfish1744933flatfish
frogfish1843943frogfish
garfish14179203_garfish
giraffish1941973giraffish
goatfish1544293goatfish
grayfishes2043633grayfishes
greyish1435173grey_ish
gruffish1843943gruffish
hagfish17227613_hagfish
headfish1845443headfish
ladyfish1843803ladyfish
oafish121311723_oa_fish
oarfish13158613_oarfish
orangish1246543orangish
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
trampish1535643trampish
waifish1637703_waifish
weakfish2143523weakfish

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162759.47015434.2
3Display Results75750.0332272.7
 (SQL Overall)178691759.65618505.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.