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

176 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
popelike1617785(None) 
pipelike16166691pipelike
ropelike14157851ropelike
apelike13310532_apelike
cokelike1336812cokelike
domelike15177752domelike
dovelike16157132dovelike
hoelike141411162ho_elike
homelike17179532homelike
hoselike15179642hoselike
noselike12158572noselike
pinelike14188612pinelike
pipeline12149502pipeline
podlike14108552po_dlike
poetlike1436732poetlike
potlike13910122po_tlike
roselike12169182roselike
tapelike1437492tapelike
toelike11149822to_elike
adobelike1642503adobelike
aguelike1344673aguelike
beelike13379783_beelike
belike124616283__belike
boatlike1457963boatlike
boltlike1436313boltlike
bowlike16349473bo_wlike
bowllike1734863bowllike
boxlike20267073bo_xlike
cagelike1537723cagelike
cavelike1738213cavelike
cocklike1536733cocklike
comblike1846293comblike
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
crapelike1744933crapelike
cuplike1537213cup_like
doglike13207453do_glike
downlike1636183downlike
dunelike1335303dunelike
eyelike1436973_eyelike
foamlike1735143foamlike
folklike1434773folklike
footlike1537253footlike
forklike1435813forklike
foxlike21226223fo_xlike
fumelike1735223fumelike
fuselike1535673fuselike
gamelike1538033gamelike
gatelike1337933gatelike
globelike1643853globelike
gluelike1335023gluelike
gnomelike1643563gnomelike
goadlike1435883goadlike
goatlike1346293goatlike
godlike1387563go_dlike
gonglike1455423gonglike
grapelike1644663grapelike
harelike1539613harelike
hiplike1637603hip_like
hoblike16158303ho_blike
hoglike15157733ho_glike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooklike1435123hooklike
hooplike1736773hooplike
hoplite12311073hop_lite
hornlike1536503hornlike
horselike1646263horselike
icelike1337173_icelike
jadelike2035993jadelike
jutelike1935333jutelike
kitelike1135733kitelike
lacelike1438493lacelike
lakelike1137383lakelike
lifelike15166223lifelike
linelike12159003linelike
liplike1337283lip_like
lobeline1039963lobeline
loftlike1534393loftlike
lordlike1345813lordlike
maplelike1744203maplelike
maplike15299273map_like
mazelike2336463mazelike
moatlike1446993moatlike
moonlike1476643moonlike
mosslike1435453mosslike
mothlike1736063mothlike
mouselike1545013mouselike
nonelite8313613nonelite
nooklike1134873nooklike
novalike1536223novalike
novelise1137953novelise
novelize2046843novelize
oaklike10268003_oaklike
oarlike113411193_oarlike
oatlike113412403_oatlike
obelise9310173_obelise
obelize1838243_obelize
opaline9412483_opaline
ovenlike1535013_ovenlike
owllike1435713_owllike
oxlike17307473_o_xlike
palmlike1656043palmlike
parklike1337483parklike
peaklike13115373peaklike
pealike131211273p_ealike
peglike14136773p_eglike
pelite84323003__pelite
piglike14157313p_iglike
pipelined14164853pipelined
pipelines13178353pipelines
piperine122011833piperine
platelike1546143platelike
playlike1735613playlike
plumlike1643793plumlike
poetise9314043po_etise
poetize18310773po_etize
polemize2148673polemize
police102918563po__lice
polite83625073po__lite
popeless1288473popeless
poperies12316793poperies
poplin10413483pop_li_n
poplins11313153pop_lins
poplitei1245483pop_litei
popple92710983poppl__e
poppling12227323poppling
popsie103013053pop_si_e
populace14256253populace
populate122812093populate
populism1446073populism
populist1248203populist
potline91015233po_tline
powderlike2051973powderlike
prelife1279943p_relife
propylite1646713propylite
pumplike1834373pumplike
puppetlike1751273puppetlike
puppylike1941583puppylike
purselike1544373purselike
puslike1347563p_uslike
pusslike1434033pusslike
rocklike1335903rocklike
rodlike1288263ro_dlike
rooflike1534623rooflike
rootlike1236613rootlike
runelike1236033runelike
smokelike1443493smokelike
soaplike1436903soaplike
songlike1336523songlike
sonlike112110713so_nlike
soullike1236813soullike
souplike1436333souplike
spikelike14103873spikelike
spinelike1585353spinelike
steplike1436733steplike
tapeline10310363tapeline
tidelike1336743tidelike
tilelike1237053tilelike
toadlike1336143toadlike
tomblike1645143tomblike
topline92313183top_line
towerlike1643263towerlike
toylike14157243to_ylike
treelike1237003treelike
tubelike1436093tubelike
vaselike1536993vaselike
viselike1536923viselike
vowelize2344763vowelize
wavelike1836613wavelike
wifelike18135253wifelike
wirelike15167493wirelike
wolflike1834063wolflike
woollike1534983woollike
wormlike1735313wormlike

Search took 9 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.250714764.0
2DLD Change Limit1461621768.31317582.3
3Display Results1761760.1101600.0
 (SQL Overall)1786911768.67320603.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.