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

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

470 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
lionfish145409(None) 
finfish16268192fi_nfish
lionfishes1643542lionfishes
lionise7310372lion_ise
longish11229092l_ongish
moonfish1675332moonfish
pinfish15319302pi_nfish
billfish1645033billfish
blindfish1842763blindfish
blondish1476173blondish
blowfish1944703blowfish
bonefish1646283_bonefish
boxfish2285543_boxfish
clingfish1842983clingfish
codfish1637163_codfish
cowfish1836433_cowfish
cronish12310863cron_ish
dogfish15226763_dogfish
donnish11187633_donnish
dronish1138913dron_ish
fiendish1544033fiendish
filefish1745593filefish
finish124613413fi_n_ish
foolfish1744393foolfish
foxfish2354483_foxfish
frogfish1843943frogfish
hogfish17257023_hogfish
ionise63516943_ion_ise
kingfish1944493kingfish
ladyfish1843803ladyfish
lemonish1347323lemon_ish
lightish1556623lightish
lioness739103lion_ess
lionised946603lion_ised
lioniser845583lion_iser
lionises8310313lion_ises
lionize1668823lion_ize
lionlike1234983lionlike
lions55923213lion__s_
littlish1145043littlish
liverish1447863liverish
loggish12258733l_oggish
loudish1137983l_oudish
loutish1039963l_outish
lowish12310533l_o_wish
lumpfish1843053lumpfish
lungfish1543963lungfish
milkfish2043333milkfish
minish115216303mi_n_ish
minxish1936213mi_nxish
monish114217593_mon_ish
monkfish2044003_monkfish
monkish1638243_monkish
moonish123311043moon_ish
ninnyish1442843ninnyish
oafish121311723__oafish
offish15137273__offish
panfish15229973_panfish
pigfish16217173pi_gfish
pilotfish1742603pilotfish
pinkish16279113pi_nkish
pipefish1844533pipefish
ribbonfish205973ribbonfish
stonefish1544073stonefish
stonish10410653ston_ish
sunfish1338883_sunfish
tilefish1445453tilefish
tonish93415903_ton_ish
tonnish10149093_tonnish
winish124212263wi_n_ish
wolfish1636933_wolfish
abolish12311504abo_lish
admonish1446034admon_ish
adonis7314064adon_is_
agonise83112694agon_ise
agonist82615404agon_ist
aiolis6316844aio_lis_
alienism1047734alien_ism
alienist8411994alien_ist
astonish1148474aston_ish
bairnish1345474bairn_ish
baitfish1645484baitfish
banish111416044_ban_ish
batfish1558684_batfish
biggish14247504bi_ggish
bindis94614584bi_ndis_
biofilm1444334bio_film
bionic103614574bion_i_c
bionics114310874bion_ics
bionomist1347114bionomist
biontic1148334bionti_c
bionts8612394bion_ts_
blackfish2343834blackfish
blandish1497004blandish
blimpish1743724bli_mpish
blinis85313684bli_n_is_
blockish19115794blockish
bluefish1645144bluefish
boarfish1635754boarfish
boarish123911914_boarish
boggish14238654_boggish
bonfire1287064_bonfire
boobish14338944_boobish
bookish163610024_bookish
boorish123712594_boorish
boyish142911234_bo_yish
brandish1469024brandish
brinish1239964brin_ish
broadish1446934broadish
broguish1444104broguish
brownish1645644brownish
burnish1238624burn_ish
catfish1559024_catfish
cavefish1974854cavefish
ceorlish1345384ceorlish
cions75222854cion__s_
clannish1345264clannish
cliquish2244024cli_quish
cloddish1544234cloddish
clonism1138984clon_ism
clownish1643804clownish
coalfish1635494coalfish
cockish1838504_cockish
coldish1399304_coldish
coltish121310934_coltish
concise11314474_concise
confess12399904_confess
confide13310204_confide
confine12315584_confine
confirm1437364_confirm
confit113316404_confi_t
confits122811424_confits
confuse1238854_confuse
consist9316034_consist
coolish12312524_coolish
coyish143710394_co_yish
crankish1736514crankish
crawfish1944234crawfish
crayfish1944254crayfish
cronyism1544724cronyism
danish101513794_dan_ish
deafish1438534_deafish
dealfish1545504dealfish
diminish14127524diminish
dioecism1344844dioecism
doggish13237534_doggish
dollish11610094_dollish
doltish11118734_doltish
dovish1338104_do_vish
draffish1844554draffish
drumfish1743504drumfish
duncish1335794_duncish
dwarfish1843784dwarfish
ebonise939614ebon_ise
elfish1267964__elfish
eonism83213534_eon_ism
evanish1337654evan_ish
faintish1446194faintish
fallfish1744464fallfish
fiftyish2042554fiftyish
finfishes1846044fi_nfishes
finis86824264fi_n_is_
fish106926274____fish
flatfish1744934flatfish
flourish1446754flourish
fogyish1735364_fogyish
folkish1736564_folkish
foolish1339614_foolish
foppish1735104_foppish
frostfish1842624frostfish
furnish1337384furn_ish
garfish14179204_garfish
garnish111610844garn_ish
ghoulish1543544ghoulish
giantism1155384giantism
giraffish1941974giraffish
girlish1137194gi_rlish
globefish1842474globefish
gnomish1345564gno_mish
goatfish1544294goatfish
goatish1139564_goatish
goldfish1644204goldfish
gonifs104310134_gonifs_
goodish1237964_goodish
goosefish1642274goosefish
goyish13379014_go_yish
grayfish1844484grayfish
groundfish1851914groundfish
gruffish1843944gruffish
hagfish17227614_hagfish
headfish1845444headfish
hennish1336864_hennish
hickish1936474hi_ckish
hippish1736184hi_ppish
hoggish15247594_hoggish
hottish13117904_hottish
huffish1935714_huffish
hunnish1336164_hunnish
impish13499194_i_mpish
incise83515334_i_ncise
infest93315434_i_nfest
infight1437454_i_nfight
infill938414_i_nfill
infirm1137044_i_nfirm
infix15337774_i_nfi_x
infos84311674_i_nfos_
infuse93110574_i_nfuse
inmesh1134864_i_nmesh
inrush936514_i_nrush
insist6314514_i_nsist
intis55121644_i_ntis_
iodise74214944_io_dise
iodism93611134_io_dism
ionic74622664_ion_i_c
ionics84214484_ion_ics
ionised82911494_ion_ised
ionises72916434_ion_ises
ionium8610924_ion_ium
ionize154613874_ion_ize
ions46737854_ion__s_
ironist7314844iron_ist
jackfish2744124jackfish
jewfish2343544_jewfish
jiggish19225944ji_ggish
jingoish19134384jingoish
jinnis13489054ji_nnis_
kiddish16276584ki_ddish
killifish1942674killifish
knish1238604__kn_ish
laconism1248044lacon_ism
laddish12299724l_addish
ladyish14287824l_adyish
lanais6316794l_anais_
languish12136254languish
laogais845814laogais_
largish1138604l_argish
larkish1439084l_arkish
latish92416174l__atish
lavish124112984l__avish
lazyish22265854l_azyish
leftish13197254l_eftish
lenis56326864l_en_is_
lentisk1136064l_entisk
leones64417724leon_es_
leonine7311234leon_ine
liaise6310694li__aise
lianas63713384lian_as_
lianes63819324lian_es_
liangs74410594lian_gs_
lianoid837534lianoi_d
libelist10310824libelist
lichis115212594li_chis_
lickerish1844424lickerish
liefest1038444li_efest
liens56525504lien__s_
lifts85719064li__fts_
lignans8398854lignans_
lignified1445064lignified
lignifies1346264lignifies
lignify1443794lign_ify
lignin74911194lign_i_n
lignins84010494lign_ins
lignite81310304lign_ite
likewise1543264likewise
limners93311564limners_
limnic10418844limn_i_c
limning103710324limn_ing
limns75718394limn__s_
limonite1048164limon_ite
linacs8310814li_nacs_
lindies8416584li_ndies
linens64818394li_nens_
liners65428854li_ners_
lines57054574li_n_es_
lingas75116574li_ngas_
lingier84113384li_ngier
lingiest93715264li_ngiest
lings67135774li_n_gs_
linguisa944474linguisa
linguist948574linguist
linier64423794li_n_ier
liniest73321154li_niest
linin58025524li_n_i_n
lining74526804li_n_ing
linins65922144li_n_ins
linking123818254li_nking
links96430194li_n_ks_
linnets739834linnets_
linns56123334li_n_ns_
linos55631504li_n_os_
lins47059054li_n__s_
lintier73613804li_ntier
lintiest82715914li_ntiest
linting83820984li_nting
lints57137194li_n_ts_
linums838284li_nums_
lion46334444lion____
lionesses939434lionesses
lionisers944174lion_isers
lionising1046464lionising
lionized1837024lionized
lionizer1756054lionizer
lionizes1738774lionizes
lionizing1947054lionizing
liquorish2152544liquorish
litchis1238374litchis_
loafing11319794l_oafing
loafs85616994l_oaf_s_
locoism1156794l_ocoism
lofts85518364l_o_fts_
loins56728424loin__s_
loners64225814l_oners_
longes75925574l_onges_
longest84114954l_ongest
longies82916554l_ongies
longing93915784l_onging
longs65527064l_on_gs_
longwise1244084l_ongwise
loofah12375814l_oof_ah
loofahs13364624l_oofahs
loofas9429834l_oofas_
loofs85623784l_oof_s_
lookism1335914l_ookism
lookist1139564l_ookist
looksism1442494looksism
looneys10487014looneys_
loonie64216454loon_i_e
loonier73312684loon_ier
loonies73919544loon_ies
looniest83313254looniest
loonily1037074loon_ily
loons55731724loon__s_
loris55329154l_o_ris_
louis57322324l_o_uis_
lumpish14127384l_umpish
lungis77113024l_ungis_
lutefisk1542694lutefisk
lutfisk1443584l_utfisk
lyonnaise1251184lyonnaise
mannish121710694_mannish
minis75432994mi_n_is_
miosis83615164mio_sis_
misoneism1343934misoneism
misoneist1147584misoneist
mobbish1635924_mobbish
modish123813544_mo_dish
monism104016314_mon_ism
monist84324984_mon_ist
moonfishes1844194moonfishes
moonrise1046784moonrise
moorish123311784_moorish
mopish134311594_mo_pish
mudfish1646264_mudfish
muttonfish1851504muttonfish
nannyish1443304nannyish
noirish1037884_noirish
noncash1245164_noncash
nourish1039704_nourish
numbfish1842604numbfish
nunnish1035934_nunnish
oarfish13158614_oarfish
oddish11107654__oddish
ogrish1039264__ogrish
oldish10169314__oldish
onrush935344__onrush
orangish1246554orangish
outfish132210574_outfish
overfish1737894overfish
owlish1238704__owlish
ozonise1646444ozon_ise
peonism11611104peon_ism
pianism11611034pian_ism
pianist9615104pian_ist
piggish14227704pi_ggish
pinfishes1746244pi_nfishes
pionic103515954pion_i_c
pions75826394pion__s_
pixieish2042604pixieish
pixyish2253654pi_xyish
planish12412054plan_ish
platyfish2042684platyfish
plenish1239944plen_ish
pliofilm1542084plio_film
polish114916724_po_lish
poorish123712304_poorish
popish133812114_po_pish
prankish1737024prankish
punish111411504_pun_ish
punkish16257694_punkish
pupfish1735534_pupfish
raffish1658844_raffish
rankish14510384_rankish
ratfish1338774_ratfish
redfish1437794_redfish
rockfish2043904rockfish
roguish1156834_roguish
rompish1436694_rompish
rosefish1445264rosefish
roundish1246254roundish
runtish1048694_runtish
sailfish1446054sailfish
sandfish1556684sandfish
sawfish1637684_sawfish
selfish1388514_selfish
serfish1348974_serfish
shortish1437424shortish
sickish1638424si_ckish
simonist10410724simon_ist
sissyish1442834sissyish
sixtyish2142684sixtyish
slobbish1544264slobbish
slowish1337634slo_wish
sniffish1744514sniffish
snobbish1544214snobbish
snoutish1145784snoutish
softish13127814_softish
sottish10129444_sottish
sourish10310694_sourish
spookish1744644spookish
standish1238544standish
starfish1438084starfish
stiffish1745244stiffish
stockfish2142854stockfish
stockish17186044stockish
stoutish1145904stoutish
strongish1344944strongish
studfish1544524studfish
suckfish2043894suckfish
surffish1744784surffish
swinish1347204swin_ish
swordfish1942224swordfish
tannish101610574_tannish
tarnish101611874tarn_ish
thinnish1454884thinnish
ticklish1755284ticklish
tigerish1246564tigerish
tigrish1137574ti_grish
toadfish1544904toadfish
toadish1139064_toadish
townish13167934_townish
toyish122911124_to_yish
trunkfish1941724trunkfish
tundish1137284_tundish
unionise847864union_ise
unionism1047014union_ism
unionist8410354union_ist
unwish1239094__unwish
vanish121513214_van_ish
varnish13169534varn_ish
vigorish1545174vigorish
violist10312144vio_list
viperfish2042944viperfish
viperish1655894viperish
vixenish2142984vixenish
voguish1465204_voguish
waifish1637704_waifish
weakfish2143524weakfish
wennish1336244_wennish
whitefish2143074whitefish
whorish1636604who_rish
widish13419364wi__dish
wildish1446854wi_ldish
wimpish1765694wi_mpish
wispish1575644wi_spish
woggish15276674_woggish
wolffish2043334wolffish
wormish1537164_wormish
yonis85020824_yon_is_
youngish1543634youngish
zanyish2235904_zanyish

Search took 14 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 Filter1786911616090.436409841.7
2DLD Change Limit16160947012.84312583.4
3Display Results4704700.1902473.7
 (SQL Overall)17869147013.46913266.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.