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

374 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
poplar10361111(None) 
polar75623451po_lar
poplars113910331poplars
popular11319561popular
bolar75123472bo_lar
collar83816172collar
copular113810602copular
dollar74110982dollar
molar75223092mo_lar
papular11299762papular
pedlar93311272pedlar
peopler1138072peopler
pepla9312862pepla_
phylar14437372phylar
pilar75221502p_ilar
pillar8314022pillar
polars84419352po_lars
poler74431792po_ler
pollard103511142pollard
poller83921852poller
pooler83819842pooler
poplin10413482poplin
poppa8409892poppa_
poppas93710712poppas
popper93615962popper
poulard10299732poulard
pupilar11125312pupilar
solar55927342so_lar
tolar55524112to_lar
volar86917412vo_lar
alar46340073__alar
alular6311353alular
ampler104313303ampler
appear10379343appear
ashlar9338193ashlar
bipolar1145453bipolar
boar66134293bo__ar
boiler84319273boiler
bola66035563bo_la_
bolas74733763bo_las
bollard103210503bollard
bopper123813833bopper
bowler114217313bowler
boxcar1734753boxcar
boyar106013763bo_yar
boyla102912363boyla_
boylas113011723boylas
byplay1634193byplay
cellar84514983cellar
coala77521123coala_
coalas87418963coalas
coaler84121703coaler
coiler84421593coiler
cola66541393co_la_
colas75436773co_las
collard103712923collard
collars93816573collars
color76123743co_lor
cooler84824713cooler
copal95621783cop_al
copalm125010813copalm
copals105018943copals
copay126516313cop_ay
coper95336093cop_er
copier103722893copier
coplanar1244473coplanar
coplot10518273coplot
copper124321893copper
coppra12306833coppra
copra98115463copra_
coprah133710603coprah
copras103517153copras
copter109822013copter
copula102812043copula_
copulae112810613copulae
copulas113811563copulas
costar85518613costar
cottar84613813cottar
cougar958783cougar
coupler114713013coupler
cupular11317623cupular
dipolar1056853dipolar
dobla84913643dobla_
doblas93812293doblas
dogear838193dogear
dollars83311023dollars
dolor67617963do_lor
dopa77220903dop_a_
dopas85019063dop_as
doper86128393dop_er
dopier93515923dopier
doula65717773doula_
doulas75114993doulas
filar84819293_filar
foliar93210973foliar
foulard11257283foulard
fouler93614903fouler
fowler123712583fowler
gopher1239183gopher
gular6314833_gular
hilar85418143_hilar
hoar76729163ho__ar
holard10410573ho_lard
holla84918493holla_
hollas94616903hollas
holler93520613holler
hoopla1147633hoopla_
hooplas1239193hooplas
hoper105829143hop_er
hopper134218483hopper
howler123514313howler
jocular1637303jocular
jowar155211433jo_war
koala95112213koala_
koalas104011663koalas
kola85124963ko_la_
kolas94822233ko_las
koppa13397293koppa_
koppas14407603koppas
lar37967533___lar
lobar7313013lo_bar
lobular936663lobular
locular938953locular
loller63315283loller
loper75129233lop_er
lopper103717203lopper
malar76424443_malar
medlar93010463medlar
modular1087363modular
moiler84017263moiler
mola66035633mo_la_
molal75120343mo_lal
molars85517323mo_lars
molas75132093mo_las
mollah11319453mollah
moola75117033moola_
moolah11409193moolah
moolas83615593moolas
moper94925923mop_er
mopier103914783mopier
mopper126215003mopper
mortar83812043mortar
morular978223morular
mylar105311533_mylar
nobler83713453nobler
nodular876703nodular
nonpar8168993nonpar
nonplay1246683nonplay
nonpolar1046283nonpolar
nonwar9159423nonwar
nopal75517103nop_al
nopals84914023nopals
noplace1137393noplace
oar37057953_o__ar
ocular8610133ocular
ogler65917443_ogler
oiler54628283_oiler
olla44821173_olla_
ollas54218283_ollas
onlay84212943_onlay
opah96218403_op_ah
opal66923523_op_al
opals75718353_opals
opera7313573_opera
osar46820953_o_sar
ottar54313993_ottar
ovular946833ovular
pabular11259473pabular
paler75436933p_aler
pallor8313673pallor
palmar104113463palmar
palpal104112053palpal
papa85827143pap_a_
papal95820673pap_al
papas94927493pap_as
papaw125112493pap_aw
paper95128663pap_er
papillar1296713papillar
papula103011113papula_
papulae11249353papulae
par57467023__p_ar
parlay113713993parlay
parlor8312673parlor
pear69745233__pear
pedlars103210213pedlars
pedlary13277543pedlary
pedler93614613pedler
peeler83517383peeler
people10310183peopl_e
peopled1238483peopled
peoplers1237153peoplers
peoples11312213peoples
peplos101211543peplos
peplum12156823peplum
peplus10138343peplus
pepper93512943pepper
phyla13469183phyla_
phylae14458733phylae
pilaf103923483p_ilaf
pilau73618523p_ilau
pilaw103913743p_ilaw
pillars9313483pillars
pilular938203pilular
pipal95118353pip_al
pipals104213643pipals
piper96523193pip_er
pipier104913983pipier
plan65833943__plan
planar84212713planar
plat66048873__plat
play95928983__play
poblano1145093poblano
pochard1537363pochard
podia8415283podia_
poilu72316003poil_u
poilus82210573poilus
poiser84217243poiser
poker115122883po_ker
pokier124914633pokier
pol56449383po_l__
polaron939843po_laron
polder94019253polder
pole65951303po_l_e
poleax1547993poleax
poled84934843po_led
polers84225643po_lers
poles75351003po_les
polio75722553po_lio
polis74731163po_lis
polka11310413po_lka
polkas1239103polkas
poll66332133po_l_l
pollack1567333pollack
pollards11299523pollards
polled94022003polled
pollee83623273pollee
pollen83416453pollen
pollers93420023pollers
pollex153711163pollex
polls74627723po_lls
polo66236633po_l_o
polos76129913po_los
pols66044563po_l_s
poly96235153po_l_y
polyp125611533po_lyp
polys105718763po_lys
ponder94521693ponder
poniard1037583poniard
pool65835953pool__
pooled94619813pooled
poolers94217423poolers
pools74427703pool_s
poor65630223po__or
poorer82613993poorer
pop76252253pop___
popcorn1344903popcorn
pope85535613pop__e
popery134511703popery
popes95933813pop_es
popgun1145733popgun
popish133812113popish
poplins11313153poplins
popover1495843popover
popped104117813popped
poppers103414863poppers
poppet92717323poppet
popple92710983popple
poppled11339233poppled
popples103011873popples
poppy114813193pop_py
pops86340953pop__s
popsie103013053popsie
popsy125713403pop_sy
populace14256253populace
popularly1663843popularly
populate122812093populate
porker124917543porker
portal84218463portal
porter84224413porter
poser75128773po_ser
poseur8419403poseur
posher115018163posher
postal84317533postal
poster84129173poster
postwar1236903postwar
pother113818853pother
potlach14106363potlach
potman102813573potman
potter83926983potter
potzer174411203potzer
poularde11276573poularde
poulards11288233poulards
poult76928873poul_t
poulter93712013poulter
poultry1235383poultry
poults84613483poults
pour611527473po__ur
pourer84516043pourer
pouter83923983pouter
powder123611903powder
power105325953po_wer
powter114116033powter
poxier153812113poxier
prelaw1139103prelaw
preplan1149953preplan
prewar114712573prewar
prolan8414693prolan
proper104319953prop_er
propman1339063propman
propyla14296633propyla_
prowar114110943prowar
prowler123310013prowler
psywar1443323psywar
pula65129373p_ula_
puler74826623p_uler
puller83820813puller
pulpal10408453pulpal
pulper103513273pulper
pulsar8329363pulsar
pupa85422813pup_a_
pupae96515643pup_ae
pupal97616873pup_al
pupas95219283pup_as
pupilary15104123pupilary
purpler11289263purpler
replan83215823replan
replay113412923replay
roar46328573ro__ar
roller63919793roller
roper75431913rop_er
ropier84118803ropier
scalar83612433scalar
shophar1555453shophar
soar46838673so__ar
sofar86115493so_far
sola45541863so_la_
solan55328153so_lan
sonar56523423so_nar
sopor74016493sop_or
soucar839323soucar
sowar85821343so_war
sowcar1135863sowcar
spar65433303_sp_ar
spear75821063_spear
splat76129343_splat
splay105816043_splay
spoiler93310683spoiler
spooler93711383spooler
sporular1065223sporular
stelar64013863stelar
stylar9358113stylar
talar56225383_talar
templar1145643templar
toiler63918283toiler
tola45236333to_la_
tolan55124013to_lan
tolars64817923to_lars
tolas54532773to_las
tollbar945443tollbar
toller63819443toller
toolbar944763toolbar
tooler63818613tooler
topaz16315323top_az
toper75231023top_er
topiary1245813topiary
topper103817603topper
unpopular1352313unpopular
uvular955563uvular
velar85817633_velar
voila84813943voila_
wooler93615873wooler
yodler10389943yodler
yowler123310043yowler
zonular1656493zonular

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163745.84319290.8
3Display Results3743740.1233040.7
 (SQL Overall)1786913746.10629264.8
 
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.