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

92 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
plumlike164379(None) 
clamlike1635162clamlike
clumplike1942602clumplike
drumlike1543792drumlike
gluelike1335022gluelike
gumlike14317402_gumlike
palmlike1656042palmlike
playlike1735612playlike
pumplike1834372p_umplike
puslike1347562p_uslike
scumlike1644352scumlike
aguelike1344673aguelike
alumine9412693alum_ine
armlike1348553_armlike
balmlike1655353balmlike
beamlike16115843beamlike
blueline1036873blueline
budlike14257873_budlike
clawlike1733913clawlike
claylike1734463claylike
cloudlike1642553cloudlike
cormlike1646703cormlike
cultlike1434933cultlike
cuplike1537213_cuplike
elflike1435133el_flike
faunlike1534763faunlike
filmlike1734443filmlike
flamelike1845063flamelike
fluidlike1742403fluidlike
flutelike1663583flutelike
foamlike1735143foamlike
fumelike1735223_fumelike
gemlike14206813_gemlike
germlike1535093germlike
glenlike1334043glenlike
gulflike1643453gulflike
gumline102810113_gumline
gutlike12308653_gutlike
hutlike14349063_hutlike
jamlike20126923_jamlike
lamblike1636153_lamblike
lawlike14137073_lawlike
leglike12136843_leglike
liplike1337283_liplike
nunlike11258073_nunlike
nutlike113110113_nutlike
palsylike1842703palsylike
parklike1337493parklike
peaklike13115373peaklike
pealike131211273p_ealike
peglike14136773p_eglike
piglike14157313p_iglike
pinelike14188613pinelike
pipelike16166693pipelike
plantlike1544943plantlike
platelike1546143platelike
plotline1037643plotline
plumage1245503plum_age
plumate1149803plum_ate
plumbic1543963plumbi_c
plumbing15286433plumbing
plumbism1643813plumbism
plume94819463plum___e
plumier113510043plum_ier
pluming123412043plum_ing
plumiped1533313plum_iped
plummier1434123plummier
plumose1135963plum_ose
plumping15277633plumping
plumpish17164733plumpish
plumule1134303plum_ule
plumulose1341773plumulose
pluralize2045773pluralize
podlike14108553p_odlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123p_otlike
pulik113613303p_u_lik_
pumice1238223p_um_ice
purline93516533p_urline
pusslike1434033pusslike
ruglike1236283_ruglike
seamlike14127183seamlike
slablike1435673slablike
slitlike1235303slitlike
soullike1236813soullike
souplike1436333souplike
stemlike1436723stemlike
sunlike112310573_sunlike
tublike1337083_tublike
unlike102614063__unlike
wormlike1735313wormlike

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 Limit146162927.14320462.3
3Display Results92920.0462000.0
 (SQL Overall)178691927.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.