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

450 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
popples10301187(None) 
hopples142810711hopples
poppies102816191poppies
popple92710981popple_
poppled11339241poppled
topples113111651topples
apples104315762_apples
couples115317052couples
dapples1238992dapples
fipples14298652fipples
hopple132910482hopple_
hoppled15338082hoppled
koppies153210012koppies
nipples11319662nipples
nopales93812522nopales
pappies103214822pappies
papules112411572papules
peoples11312222peoples
pimples133012422pimples
poles75351002po__les
poodles103013512poodles
popeless1288472popeless
popes95933812po_p_es
poppas93710712popp_as
popped104117812popp_ed
popper93615962popp_er
poppers103414862poppers
poppet92717322popp_et
poppets10338852poppets
poppied11388982poppied
popsies112816462popsies
posoles9314882posoles
potpies113116172potpies
pottles93816982pottles
pozoles1839062pozoles
puppies103212612puppies
purples112712832purples
ripples113513292ripples
stopples1236952stopples
supples11511282supples
tipples112811252tipples
topple104411322topple_
toppled12348842toppled
ampules1189433ampules
apoapses1244713apoapses
apostles1037753apostles
appels104312793_appels
apple94517673_apple_
applet105917433_applet
applets115710063_applets
applies11311213_applies
bobbles104514913bobbles
boggles113411823boggles
bogles95020833bo_gles
boles75448603bo__les
boodles103416043boodles
bopped134413403bopp_ed
bopper123813833bopp_er
boppers133911923boppers
bottles94216273bottles
boucles113113003boucles
boules84925973bo_ules
boulles93114123boulles
buppies133011063buppies
cobbles133814823cobbles
cobles104622883co_bles
cockles153414643cockles
coddles114213593coddles
coffles152610003coffles
coles76055063co__les
compels133210883compels
compiles14311983compiles
complex2037243complex
complies14314523complies
copalms13367543copalms
copals105018943copal_s
copes97747103co_p_es
copies104130303co_pies
copped135221253copp_ed
copper124321893copp_er
coppers133519753coppers
coppices1638243coppices
coppras13327833coppras
copses104922473co_pses
copulas113811563copulas
corpses113913803corpses
coupes105022523coup_es
couple104415963couple_
coupled124312673coupled
coupler114713013coupler
couplers123311323couplers
couplet114717943couplet
couplets12389873couplets
cowpies143314283cowpies
cripples14298403cripples
croppies143111133croppies
cupules113210263cupules
dapple1138853dapple_
dappled1336393dappled
dimples122813213dimples
dipoles101013753dipoles
doles67843753do__les
dongles93212873dongles
doodles93614163doodles
dopes84935043do_p_es
dottles83912283dottles
doubles103113353doubles
empales112411433empales
epopees1137233epo_pees
fipple13329063fipple_
floppies1546813floppies
foibles1238853foibles
folles93820473fo_lles
fondles113512613fondles
footles103715713footles
foozles19329543foozles
fopped144012673fopp_ed
gobbles123512583gobbles
goggles103510793goggles
gospels1035593gospels
grapples13348123grapples
guppies123310523guppies
hippies142813743hippies
hirples12149643hirples
hobbles143313783hobbles
holes84748653ho__les
hondles113614523hondles
hooplas1239203hooplas
hoopless13279263hoopless
hoopoes121212483hoopoes
hopeless13118303hopeless
hopes105835643ho_p_es
hopped144318113hopp_ed
hopper134218483hopp_er
hoppers143115143hoppers
hoppier143110703hoppier
hoppiest152610723hoppiest
hoyles12315013ho_yles
impales113311763impales
joggles164410413joggles
joles125230833jo__les
jostles143411143jostles
joules134116823jo_ules
kopjes1935363ko_pjes
koppas14407603kopp_as
koppie14277883koppie_
lobules92510813lobules
locales93715093locales
locules92812603locules
lopes76437343lo_p_es
lopped114218623lopp_ed
lopper103717203lopp_er
loppers113014103loppers
loppier11369723loppier
loppiest122410103loppiest
loupes84918053loup_es
maples104819423_maples
mobiles112813123mobiles
modules102511003modules
moles74747923mo__les
mopes95134983mo_p_es
mopokes1536693mopokes
mopped134114323mopp_ed
mopper126215003mopp_er
moppers133412463moppers
moppet126915093mopp_et
moppets13307163moppets
morales93619403morales
motiles93317433motiles
mottles93415803mottles
nappes104515623napp_es
nappies114613393nappies
nipple103410373nipple_
nippled12307643nippled
nobbles114014523nobbles
nobles83319723no_bles
noddles92911293noddles
nodules8269703nodules
nombles113212343nombles
nonplus936183nonplus
nonuples1056533nonuples
noodles83513193noodles
nopals84914023nopal_s
nozzles15276303nozzles
oboles83815833_oboles
odyles10348563_odyles
ogles65223183_o_gles
oles46453473_o__les
oodles73517183_oodles
opals75718353_opal_s
opes65942613_o_p_es
opines84820703_opines
oppose1039193_oppose
opposes1149243opposes
oppress1135993_oppress
opuses84012243_opuses
orles55326213_o_rles
ouphes113614633_ouphes
ovules938223_ovules
paddles113515643paddles
padles95221123p_adles
pales75753803__pales
pappier103511593pappier
pappiest112611113pappiest
pappose1047413pappose
pappous1057463pappous
pappus9408373papp_us
papule102212133papule_
parles86334403p_arles
paroles95025883paroles
pebbles1337573pebbles
peddles112913703peddles
peles75738083__peles
people10310193people_
peopled1238503peopled
peopler1138083peopler
peoplers1237163peoplers
peplos101211543p_eplos
peplus10138343p_eplus
pepped103113403pepp_ed
pepper93512943pepp_er
peppers103311443peppers
peppier10268323peppier
peppiest11278563peppiest
perplex1836153perplex
pestles93217693pestles
pettles93916483pettles
pickles153215443pickles
piddles114314273piddles
piffles15368763piffles
piles74742613__piles
pilules9510623pilules
pimple123512963pimple_
pimpled14289193pimpled
pinoles93418703pinoles
pintles94118723pintles
pipages1289423pipages
pipals104213643pipal_s
pipeless12107663pipeless
pipes96030143p_ip_es
pipped104516543pipp_ed
pippins10319753pippins
pizzles17329273pizzles
plopped11288773plopp_ed
poaches144416943poaches
podites103014733podites
poesies93217403poesies
poetless1038723poetless
pogies94123543po_gies
poilus82210573po_ilus
pointes93216753pointes
poises84226543po_ises
pokes116133013po__kes
pokies125921333po_kies
pole65951303po__le_
poled84934843po__led
poleis86018353po__leis
poleless1089873poleless
poler74431793po__ler
polers84225643po__lers
polices113118053polices
polies84034583po_lies
polis74731163po__lis
polled94022003po_lled
pollee83623273po_llee
pollees93215333pollees
pollen83416453po_llen
pollens93713303po_llens
poller83921853po_ller
pollers93420023po_llers
pollex153711163po_llex
polls74627723po__lls
polos76129913po__los
pols66044563po__l_s
polys105718763po__lys
pomaces132712123pomaces
pomades123711733pomades
pomelos11218133pomelos
pomes94833933po__mes
pommels13235783pommels
pommies133712843pommies
pompoms1535333pompoms
pompons1338553pompons
pompous1338063pompous
pomps115316193pomp__s
ponces104720843po_nces
pones74547043po__nes
pongees104212543pongees
ponies84833463po_nies
pontes83627853po_ntes
pooches143214163pooches
poodle93112043poodle_
pooled94619813po_oled
pooler83819843po_oler
poolers94217423po_olers
pools74427703po_ol_s
pooped113915943poop_ed
poops94422413poop__s
pooves113914713po_oves
pope85535613po_p_e_
poperies12316793poperies
popeyed1535713popeyed
popguns1234023popguns
poplar103611113po_plar
poplars113910333poplars
poplin10413483po_plin
poplins11313153poplins
popover1495843popover
popovers1595663popovers
poppa8409893popp__a
popping113715413popping
poppling12227323poppling
poppy114813193popp__y
pops86340953po_p__s
popsicles1543663popsicles
popsie103013053popsie_
populaces15195713populaces
popular11319563popular
populates132710673populates
populism1446073populism
populist1248203populist
populous1245953populous
porches143815673porches
pores75849033po__res
porgies103017003porgies
porkies133416493porkies
porkpies1636193porkpies
portless10310643portless
poses74642763po__ses
posies84431433po_sies
posole8314223posole_
posses85128803po_sses
posties93128813posties
potables12179703potables
potages102416423potages
potholes13312933potholes
potpie103412433potpie_
potsies93019483potsies
potties93723543potties
pottle84416103pottle_
pouches144116743pouches
pouffes15408123pouffes
poults84613483po_ults
pounces114113893pounces
poxes145325723po__xes
pozole1758913pozole_
preppies1149683preppies
profiles133211233profiles
proles84627203p_roles
propanes122415823propanes
propels113412843propel_s
propenes122816513propenes
propines122618933propines
propolis12311403propolis
propones122516963propones
proposes122515973proposes
propped113311953propp_ed
propyls14308193propyl_s
protyles13249833protyles
puddles113613823puddles
pules74538813__pules
pulpless12224953pulpless
pumpless14236373pumpless
pungles104013713pungles
pupates113311433pupates
pupils10389913pupil_s
pupped105013273pupp_ed
puppet93514593pupp_et
puppets10317013puppets
purfles122511843purfles
purple102712683purple_
purpled12299783purpled
purpler11289273purpler
purplest12249133purplest
puzzles17318973puzzles
rappees113611453rappees
rappels11448803rappels
rimples113114223rimples
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripplers12337113ripplers
ripplet113412583ripplet
ripplets12316733ripplets
robles85321693ro_bles
roles56747983ro__les
rootles73215633rootles
ropes75940063ro_p_es
roubles93413513roubles
rumples113313133rumples
samples112815453samples
shoppes143411393shopp_es
simples113014943simples
soapless10278073soapless
socles8418453so_cles
soles55547923so__les
sophies12314613sophies
sopites93817173sopites
sopped114819903sopp_ed
soppier112711583soppier
soppiest122511933soppiest
soupless10268463soupless
spales84728103_spales
spiles84227913_spiles
sporules1037703sporules
staples93617213staples
stipples1247023stipples
stopple1156583stopple_
stoppled1345003stoppled
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supplest1248943supplest
supplies1268833supplies
swiples12339643swiples
swipples1534843swipples
temples112610893temples
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipplers12336353tipplers
toddles93211533toddles
toggles93710973toggles
toiles63923513to_iles
toles55147133to__les
tootles72915603tootles
topazes1857313topazes
topees85519703to_pees
topes76941763to_p_es
tophes115218423to_phes
topless92511123to_pless
topped114617723topp_ed
topper103817603topp_er
toppers113914603toppers
toupees938513toupees
tousles74113933tousles
touzles16359223touzles
triples94616873triples
unpiles92112783unpiles
uppiles11208263uppiles
voiles94616443vo_iles
voles86234043vo__les
wimples143311173wimples
wobbles143412433wobbles
woopses1237883woopses
yippies14279293yippies
yodles103714333yo_dles
yuppies14339263yuppies
zeppoles2143583zeppoles
zonules1647793zonules

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 Filter1786911340270.390458182.1
2DLD Change Limit1340274506.04622167.9
3Display Results4504500.1562884.6
 (SQL Overall)1786914506.59227107.3
 
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.