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

154 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
publish144791(None) 
bullish12511192bullish
copublish1843262copublish
cubbish1635802cubbish
dullish1148742dullish
mulish11311902mu_lish
palish114718272p_alish
polish114916722p_olish
pubis94616472pub_is_
public12238142publi_c
publics13207142publics
published1744342published
publisher1644212publisher
publishes1645932publishes
puckish18237212puckish
puggish14265992puggish
pulis74225602pu_lis_
punish111411502pu_nish
punkish16257692punkish
pupfish1735532pupfish
purplish1554932purplish
republish1643822republish
rubbish1436302rubbish
ablush1147223_ablush
abolish12311503abolish
babyish1736513babyish
biblist11310833biblist
bliss75616913__bliss
bluish1159243__bluish
blush105115313__blush
bubalis11359903bubalis_
buckish18237883buckish
burnish1238623burnish
carlish12312773carlish
churlish1644903churlish
clubbish1743813clubbish
coolish12312523coolish
cubism12348703cub_ism
cubist104214443cub_ist
cuish10313173cu__ish
cullis84115993cullis_
cultish12139113cultish
currish1238353currish
delish105215613_delish
dollish11610093dollish
dualism1049163dualism
dualist8614053dualist
dudish1148313du_dish
duelist8511413duelist
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
english1137953english
feeblish1644163feeblish
foolish1339613foolish
furbish1536443furbish
furnish1337383furnish
girlish1137193girlish
hellish13310723hellish
hubris11218973hubris_
huffish1935713huffish
hunnish1336163hunnish
lumpish14127383lumpish
mobbish1635923mobbish
mudfish1646263mudfish
nebbish1444253nebbish
numbfish1842603numbfish
nunnish1035933nunnish
outblush1343753outblush
outfish132210573outfish
outwish13289853outwish
owlish1238703_owlish
panfish15229973panfish
parish115022353p_arish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
perish114619063p_erish
perkish16258823perkish
pettish1238283pettish
pigfish16217173pigfish
piggish14227703piggish
pilis75825203p_ilis_
pinfish15319303pinfish
pinkish16279113pinkish
pish96127913p___ish
pixyish2253653pixyish
planish12412053planish
plash104616563p__lash
plenish1239943plenish
plumpish17164733plumpish
plush105614713p__lush
polis74731163p_olis_
pollist9816603pollist
poorish123712303poorish
popish133812113p_opish
prudish1376563prudish
pubes94423403pub_es_
pubic114513723pub_i_c
publican1444543publican
publicise1544223publicise
publicist1545033publicist
publicly1743313publicly
publishers1743523publishers
publishing1844003publishing
pubs85029213pub__s_
pueblos1134843pueblos_
pugilism13144683pugilism
pugilist11136633pugilist
pules74538813pu_les_
puli65527623pu_li__
pulik113613303pu_li_k
puling93621403pu_ling
pulling103821073pulling
pulls74425053pu_lls_
pulps95116483pu_lps_
puls65437563pu_l_s_
pulse74219973pu_l_se
punjis1536693punjis_
pupils10389913pupils_
puppyish1742453puppyish
purblind1345163purblind
puris75332023pu_ris_
purism104715063pu_rism
purist85525053pu_rist
purlieu938143purlieu
purlin83615863purli_n
purline93516533purline
purling103620293purling
purlins93415423purlins
purls74723353purl_s_
push95526623pu___sh
puslike1347563puslike
qualmish2244013qualmish
relish93916953_relish
rubbishy1842153rubbishy
rubles83921703rubles_
runtish1048693runtish
ruttish1048303ruttish
stablish1348343stablish
stylish13197443stylish
sublime11310363sublime
subline9316893subline
submiss1138083submiss
subsist9311573subsist
sunfish1338883sunfish
tallish103313583tallish
tubaist938703tubaist
tubist83013163tub_ist
tublike1337083tublike
tundish1137283tundish
unlash938793_unlash
unwish1239093_unwish
uppish1336633_uppish

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.390458182.1
2DLD Change Limit1340271546.83019623.3
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.28024545.5
 
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.