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]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
stonefish1544063stonefish
stonish10410653ston_ish
sunfish1338883_sunfish
tilefish1445453tilefish
tonish93415903_ton_ish
tonnish10149093_tonnish
winish124212263wi_n_ish
wolfish1636933_wolfish

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 Filter1786911461620.420425454.8
2DLD Change Limit146162716.75021653.6
3Display Results71710.0302366.7
 (SQL Overall)178691717.20024818.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.