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

206 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
codfish163716(None) 
cowfish1836431cowfish
boxfish2285542boxfish
caddish143810122caddish
catfish1559022catfish
cloddish1544232cloddish
coalfish1635492coalfish
cockish1838502cockish
codfishes1845642codfishes
coldish1399302coldish
coltish121310932coltish
coolish12312522coolish
coyish143710392co_yish
dogfish15226762dogfish
foxfish2354482foxfish
goldfish1644202goldfish
hogfish17257022hogfish
modish123813542mod_ish
mudfish1646262mudfish
oafish121311722_oafish
oddish11107652_oddish
offish15137272_offish
redfish1437792redfish
toadfish1544902toadfish
wolfish1636932wolfish
batfish1558683batfish
blowfish1944703blowfish
boarfish1635753boarfish
boarish123911913boarish
boggish14238653boggish
bonefish1646283bonefish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boyish142911233bo_yish
caddis104613383caddis_
cadis84428503cad_is_
carlish12312763carlish
cattish12410723cattish
cavefish1974853cavefish
cedis84317083ced_is_
ceorlish1345383ceorlish
cherish15310463cherish
clayish1547943clayish
clownish1643803clownish
coatis85122603coatis_
codas84724243cod_as_
codding124014693codding
codecs115112933codecs_
codeia94112193codei_a
codeias103911223codeias
codein94916723codei_n
codeina104010323codeina
codeine103815033codeine
codeins103715483codeins
codens94821013codens_
coders95426983coders_
codes86247293cod_es_
codified1537403codified
codifier1447163codifier
codifies1439643codifies
codify1537163cod_ify
coding104024793cod_ing
codlin94516443codli_n
codling114418953codling
codlins104116243codlins
codons96119463codons_
codrive1337653codrive
cods76848103cod__s_
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_
cowfishes2045723cowfishes
crawfish1944233crawfish
crayfish1944253crayfish
cronish12310863cronish
cubbish1635803cubbish
cuish10313173c__uish
cultish12139113cultish
currish1238353currish
deafish1438533deafish
dish86328333__d_ish
dodoism1135893dodoism
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
dowdyish1952833dowdyish
dudish1148313dud_ish
elfish1267963_elfish
faddish15359003faddish
finfish16268193finfish
fish106926273___fish
fogyish1735363fogyish
folkish1736563folkish
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
frogfish1843943frogfish
garfish14179203garfish
goatfish1544293goatfish
goatish1139563goatish
goodish1237963goodish
goyish13379013go_yish
hagfish17227613hagfish
headfish1845443headfish
hoggish15247593hoggish
hottish13117903hottish
huffish1935713huffish
iodise74214943iod_ise
iodism93611133iod_ism
jadish17319903jad_ish
jewfish2343543jewfish
kaddish16317973kaddish
kiddish16276583kiddish
laddish12299723laddish
ladyfish1843803ladyfish
ladyish14287823ladyish
lionfish1454093lionfish
loggish12258723loggish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
maddish14289483maddish
mobbish1635923mobbish
monish114217593mo_nish
monkfish2044003monkfish
monkish1638243monkish
moonfish1675333moonfish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
noirish1037883noirish
nourish1039703nourish
oarfish13158613oarfish
odist6421913_od_ist
ogrish1039263_ogrish
oldish10169313_oldish
outfish132210573outfish
owlish1238703_owlish
panfish15229973panfish
pigfish16217173pigfish
pinfish15319303pinfish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
pupfish1735533pupfish
radish103516913rad_ish
raffish1658843raffish
ratfish1338773ratfish
reddish1238033reddish
rockfish2043903rockfish
roguish1156833roguish
rompish1436693rompish
rosefish1445263rosefish
rowdyish1852663rowdyish
sandfish1556683sandfish
sawfish1637683sawfish
selfish1388513selfish
serfish1348973serfish
softish13127813softish
sottish10129443sottish
sourish10310693sourish
studfish1544523studfish
sunfish1338883sunfish
swordfish1942223swordfish
toadish1139063toadish
toadyish1544153toadyish
tonish93415903to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
voguish1465203voguish
waifish1637703waifish
widish13419363wid_ish
woggish15276673woggish
wolffish2043333wolffish
wormish1537163wormish

Search took 8 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.470380193.6
2DLD Change Limit1340272067.06318975.9
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.60923484.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.