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

173 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
dogfish1522676(None) 
doggish13237531doggish
hogfish17257021hogfish
boggish14238652boggish
boxfish2285542boxfish
codfish1637162codfish
cowfish1836432cowfish
deafish1438532deafish
dogfight1742992dogfight
dogfishes1745082dogfishes
dollish11610092dollish
doltish11118732doltish
donnish11187632donnish
dovish1338102do_vish
fogyish1735362fogyish
foxfish2354482foxfish
frogfish1843942frogfish
hagfish17227612hagfish
hoggish15247592hoggish
loggish12258732loggish
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
dampish1567663dampish
danish101513793d_anish
darkish1537943darkish
dealfish1545503dealfish
defis96717503d_efis_
delish105215613d_elish
dervish1436983dervish
dish86328333d___ish
dodoism1135893dodoism
doffing15357793doffing
doffs125614333do_ffs_
doges75630163dog_es_
dogeys115510663dogeys_
dogface1454053dogface
dogfights1842033dogfights
doggie93910893doggi_e
doggier103810943doggier
doggies103613023doggies
doggiest113410523doggiest
dogging113312693dogging
doggishly1842893doggishly
dogie75222793dog_i_e
dogies85022253dog_ies
doglike13207453doglike
dogmas105011243dogmas_
dogs66440153dog__s_
doofus1036163doofus_
dowdyish1952833dowdyish
draffish1844553draffish
dreggish1453133dreggish
dronish1138913dronish
drumfish1743503drumfish
dryish1336323d_ryish
dudish1148313d_udish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
dwarfish1843783dwarfish
elfish1267963_elfish
english1137953english
finfish16268193finfish
fish106926273___fish
fogeyish1843843fogeyish
fogyism1643943fogyism
folkish1736563folkish
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
garfish14179203garfish
goatfish1544293goatfish
goatish1139563goatish
goldfish1644203goldfish
goodish1237963goodish
goyish13379013go_yish
haggish15207473haggish
hogfishes1944683hogfishes
hogwash1742713hogwash
hottish13117903hottish
huffish1935713huffish
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
softish13127813softish
sottish10129443sottish
sourish10310693sourish
sunfish1338883sunfish
tigrish1137573tigrish
toadfish1544903toadfish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
toughish1545283toughish
townish13167933townish
toyish122911123to_yish
waggish15207073waggish
waifish1637703waifish
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.500357382.0
2DLD Change Limit1340271735.89022755.0
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.45327691.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.