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

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

174 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
hogfish1725702(None) 
dogfish15226761dogfish
hagfish17227611hagfish
hoggish15247591hoggish
boggish14238652boggish
boxfish2285542boxfish
codfish1637162codfish
cowfish1836432cowfish
doggish13237532doggish
fogyish1735362fogyish
foxfish2354482foxfish
frogfish1843942frogfish
haggish15207472haggish
hogfishes1944682hogfishes
hogwash1742712hogwash
hottish13117902hottish
huffish1935712huffish
loggish12258722loggish
oafish121311722_oafish
offish15137272_offish
ogrish1039262_ogrish
pigfish16217172pigfish
roguish1156832roguish
voguish1465202voguish
woggish15276672woggish
wolfish1636932wolfish
aguish1059283_aguish
anguish11117633anguish
batfish1558683batfish
biggish14247503biggish
blowfish1944703blowfish
boarfish1635753boarfish
boarish123911913boarish
bogyism1545213bogyism
bonefish1646283bonefish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boyish142911233bo_yish
broguish1444103broguish
catfish1559023catfish
coalfish1635493coalfish
cockish1838503cockish
cognise1059683cognise
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
coyish143710393co_yish
deafish1438533deafish
dogfight1742993dogfight
dogfishes1745083dogfishes
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
elfish1267963_elfish
english1137953english
finfish16268193finfish
fish106926273___fish
fogeyish1843843fogeyish
fogyism1643943fogyism
folkish1736563folkish
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
garfish14179203garfish
ghoulish1543543ghoulish
goatfish1544293goatfish
goatish1139563goatish
goldfish1644203goldfish
goodish1237963goodish
goyish13379013go_yish
hagbush1642623hagbush
hagfishes1945153hagfishes
haggis11209513haggis_
haimish1537753haimish
hashish1238353hashish
hawkish2036553hawkish
headfish1845443headfish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
hickish1936473hickish
hippish1736183hippish
hoboism1446623hoboism
hogans105914313hogans_
hogging133112803hogging
hoggishly2042953hoggishly
hoggs107212463hog_gs_
hoglike15157733hoglike
hognose11117243hognose
hogs87139663hog__s_
hogtie102711773hogti_e
hogtied12226653hogtied
hogties112813993hogties
hoise85224773ho__ise
hoist86433213ho__ist
holism113713753ho_lism
holist94723213ho_list
hoofing143912553hoofing
hoofs115721043hoof_s_
hornist102314823hornist
houris94514583houris_
howffs18535043howffs_
howfs144814503howf_s_
hunnish1336163hunnish
hygeist1445793hygeist
jewfish2343543jewfish
jiggish19225943jiggish
kingfish1944493kingfish
lionfish1454093lionfish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
lungfish1543963lungfish
mobbish1635923mobbish
modish123813543mo_dish
monish114217593mo_nish
monkfish2044003monkfish
monkish1638243monkish
moonfish1675333moonfish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mudfish1646263mudfish
noirish1037883noirish
nourish1039703nourish
oarfish13158613oarfish
oddish11107653_oddish
ogreish1134673_ogreish
ogrism937913_ogrism
oldish10169313_oldish
outfish132210573outfish
owlish1238703_owlish
panfish15229973panfish
piggish14227703piggish
pinfish15319303pinfish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
puggish14265993puggish
pupfish1735533pupfish
raffish1658843raffish
ratfish1338773ratfish
redfish1437793redfish
rockfish2043903rockfish
rompish1436693rompish
rosefish1445263rosefish
roughish1545213roughish
sawfish1637683sawfish
selfish1388513selfish
serfish1348973serfish
shogis103810943shog_is_
shortish1437423shortish
softish13127813softish
sottish10129443sottish
sourish10310693sourish
sunfish1338883sunfish
thuggish1642653thuggish
tigrish1137573tigrish
toadfish1544903toadfish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
toughish1545283toughish
townish13167933townish
toyish122911123to_yish
waggish15207073waggish
waifish1637703waifish
whorish1636603who_rish
wolffish2043333wolffish
wormish1537163wormish
yogis95617743yog_is_

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271746.59320328.7
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.81226231.8
 
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.