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

193 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
cowfish183643(None) 
codfish1637161codfish
blowfish1944702blowfish
boxfish2285542boxfish
catfish1559022catfish
clownish1643802clownish
coalfish1635492coalfish
cockish1838502cockish
coldish1399302coldish
coltish121310932coltish
coolish12312522coolish
cowfishes2045722cowfishes
coyish143710392co_yish
crawfish1944232crawfish
dogfish15226762dogfish
foxfish2354482foxfish
hogfish17257022hogfish
jewfish2343542jewfish
lowish12310532low_ish
oafish121311722_oafish
offish15137272_offish
owlish1238702_owlish
sawfish1637682sawfish
townish13167932townish
wolfish1636932wolfish
batfish1558683batfish
boarfish1635753boarfish
boarish123911913boarish
boggish14238653boggish
bonefish1646283bonefish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
bowfin14338353bowfi_n
bowfins15267703bowfins
boyish142911233bo_yish
brownish1645643brownish
caddish143810123caddish
carlish12312763carlish
cattish12410723cattish
cavefish1974853cavefish
ceorlish1345383ceorlish
cherish15310463cherish
clayish1547943clayish
cloddish1544233cloddish
coatis85122603coatis_
codfishes1845643codfishes
coexist1638583coexist
coffin14339813coffi_n
coffing163811253coffing
coffins153110193coffins
coffs134916303co_ffs_
cognise1059683cognise
cohosh14517123co_hosh
coifing133213893coifing
coifs105718703coif_s_
comfier1439163comfier
comfiest1539133comfiest
comfit133112423comfi_t
comfits14328743comfits
concise11314473concise
confess12399903confess
confide13310203confide
confine12315583confine
confirm1437363confirm
confit113316403confi_t
confits122811423confits
confuse1238853confuse
consist9316033consist
coofs105924713coof_s_
copyist1439053copyist
corgis9314413corgis_
cosh96127623co___sh
cosmism1337013cosmism
cosmist11311333cosmist
coulis84018763coulis_
cowbind1536613cowbind
cowbird1534433cowbird
cowers114625533cowers_
cowflap1742503cowflap
cowflop1742893cowflop
cowgirl1353273cowgirl
cowhide1636133cowhide
cowier113616163cow_ier
cowiest123614673cowiest
cowing124526323cow_ing
cowlick1835263cowlick
cowling134017413cowling
cowls106922213cow_ls_
cowpie133511513cowpi_e
cowpies143314283cowpies
cowrie113814283cowri_e
cowries124218013cowries
cowrite123612683cowrite
cows97046643cow__s_
crayfish1944253crayfish
cronish12310863cronish
cubbish1635803cubbish
cuish10313173c__uish
cultish12139113cultish
currish1238353currish
deafish1438533deafish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
dowdyish1952833dowdyish
elfish1267963_elfish
finfish16268193finfish
fish106926273___fish
fogyish1735363fogyish
folkish1736563folkish
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
frogfish1843943frogfish
garfish14179203garfish
gawkish1835833gawkish
goatfish1544293goatfish
goatish1139563goatish
goldfish1644203goldfish
goodish1237963goodish
goyish13379013go_yish
hagfish17227613hagfish
hawkish2036553hawkish
hoggish15247593hoggish
hottish13117903hottish
howffs18535043howffs_
howfs144814503howf_s_
huffish1935713huffish
lionfish1454093lionfish
loggish12258723loggish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
mawkish1935823mawkish
mobbish1635923mobbish
modish123813543mo_dish
monish114217593mo_nish
monkfish2044003monkfish
monkish1638243monkish
moonfish1675333moonfish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mudfish1646263mudfish
newish1237903new_ish
noirish1037883noirish
nourish1039703nourish
nowise9511073now_ise
oarfish13158613oarfish
oddish11107653_oddish
ogrish1039263_ogrish
oldish10169313_oldish
outfish132210573outfish
panfish15229973panfish
pigfish16217173pigfish
pinfish15319303pinfish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
pupfish1735533pupfish
raffish1658843raffish
ratfish1338773ratfish
rawish123012913raw_ish
redfish1437793redfish
rockfish2043903rockfish
roguish1156833roguish
rompish1436693rompish
rosefish1445263rosefish
rowdyish1852663rowdyish
selfish1388513selfish
serfish1348973serfish
slowish1337633slow_ish
softish13127813softish
sottish10129443sottish
sourish10310693sourish
sunfish1338883sunfish
swish115114823_sw_ish
toadfish1544903toadfish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
toyish122911123to_yish
unwish1239093unw_ish
voguish1465203voguish
waifish1637703waifish
whish144512923__whish
wish107228733__w_ish
woggish15276673woggish
wolffish2043333wolffish
wormish1537163wormish

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 Limit1340271936.62620227.4
3Display Results1931930.0762539.5
 (SQL Overall)1786911936.85826055.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.