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

112 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
pumplike183437(None) 
clumplike1942602clumplike
cuplike1537212cu_plike
fumelike1735222fumelike
gumlike14317402gum_like
hemplike1936122hemplike
plumlike1643792plum_like
puppylike1941582puppylike
puslike1347562pu_slike
pusslike1434032pusslike
tumpline1237112tumpline
armlike1348553arm_like
auntlike1234983auntlike
budlike14257873bu_dlike
bushlike1734963bushlike
comblike1846293comblike
complice1639333complice
compline14313553compline
cultlike1434933cultlike
domelike15177753domelike
drumlike1543793drum_like
dumpling14217893dumpling
dumpsite1344293dumpsite
dunelike1335303dunelike
dustlike1335363dustlike
fuselike1535673fuselike
gamelike1538033gamelike
gemlike14206813gem_like
gulflike1643453gulflike
gumline102810113gum_line
gutlike12308653gu_tlike
hiplike1637603_hiplike
homelike17179533homelike
hooplike1736773hooplike
humanlike1843283humanlike
husklike1433613husklike
hutlike14349063hu_tlike
hymnlike2043123hymnlike
jamlike20126923jam_like
jutelike1935333jutelike
lamblike1636153lamblike
liplike1337283_liplike
maplike15299273_maplike
muspike1536043musp_ike
nunlike11258073nu_nlike
nutlike113110113nu_tlike
palmlike1656043palmlike
parklike1337493parklike
peaklike13115373peaklike
pealike131211273p_ealike
peglike14136773p_eglike
pemoline12310273pemoline
piglike14157313p_iglike
pimple123512963pimpl__e
pimplier1445413pimplier
pinelike14188613pinelike
pipelike16166693pipelike
playlike1735613playlike
podlike14108553p_odlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123p_otlike
pulik113613303pu__lik_
pumice1238223pum__ice
pumicite1446813pumicite
pumping144213553pump_ing
pumpkin1743523pumpki_n
pumpkins1843853pumpkins
pumpless14236373pumpless
puppetlike1751273puppetlike
purline93516533pu_rline
purple102712683purpl__e
purpling1368543purpling
purplish1554933purplish
purselike1544373purselike
puttylike1841813puttylike
quaylike2434143quaylike
rampike1536603ramp_ike
rubylike1753353rubylike
rufflike1843253rufflike
ruglike1236283ru_glike
rumple103913013rumpl__e
rumplier1235303rumplier
rumpling13178763rumpling
runelike1236033runelike
rushlike1534333rushlike
scumlike1644353scum_like
semplice1447013semplice
soaplike1436903soaplike
souplike1436333souplike
steplike1436733steplike
suchlike1735123suchlike
suitlike1236313suitlike
sunlike112310573su_nlike
surflike1535933surflike
surplice1246203surplice
tomblike1645143tomblike
traplike1437653traplike
tubelike1436093tubelike
tublike1337083tu_blike
tuliplike1542203tuliplike
tumorlike1542773tumorlike
tumplines1346023tumplines
turflike1534443turflike
tusklike1133583tusklike
umpire1047893_ump_ire
unalike11311533_unalike
unlike102614063_u_nlike
urnlike1136713_urnlike
wasplike1734893wasplike
whiplike2043813whiplike
wisplike1734713wisplike

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 Limit1461621127.26620115.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.73223110.6
 
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.