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

407 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
poppled1133924(None) 
hoppled15338081hoppled
popped104117811popp_ed
poppied11388981poppied
popple92710981popple_
popples103011871popples
toppled12348841toppled
bopped134413402bopp_ed
copped135221252copp_ed
coupled124312672coupled
dappled1336392dappled
fopped144012672fopp_ed
hopped144318112hopp_ed
hopple132910482hopple_
hopples142810712hopples
lopped114218622lopp_ed
mopped134114322mopp_ed
nippled12307642nippled
peopled1238502peopled
pepped103113402pepp_ed
pimpled14289192pimpled
pipped104516542pipp_ed
plopped11288772plopp_ed
poled84934842po__led
polled94022002po_lled
pooled94619812po_oled
pooped113915942poop_ed
popeyed1535712popeyed
popper93615962popp_er
poppet92717322popp_et
poppies102816192poppies
propped113311952propp_ed
pupped105013272pupp_ed
purpled12299782purpled
rippled123110272rippled
sopped114819902sopp_ed
stoppled1345002stoppled
suppled1248462suppled
tippled12358392tippled
topped114617722topp_ed
topple104411322topple_
topples113111652topples
apple94517673_apple_
apples104315763_apples
applet105917433_applet
applied1247483_applied
bobbled113811833bobbled
bobsled12297153bobsled
boggled12409003boggled
boiled95020953bo_iled
bolled94722653bo_lled
boodled113410933boodled
bopper123813833bopp_er
bottled104611233bottled
boweled132810693boweled
bowled125018143bo_wled
capped134721853capp_ed
chopped174511003chopp_ed
clopped143611523clopp_ed
coaled95022713co_aled
coapted123911503coapted
cobbled143411633cobbled
cockled163710823cockled
coddled123410573coddled
coffled16297363coffled
coiled95123943co_iled
coled85540763co__led
comped135919873comp_ed
compiled1537813compiled
complex2037243complex
complied1539673complied
compted143813523compted
cooled95224593co_oled
cooped114821603coop_ed
coopted123710763coopted
coped105036843co_p_ed
copied114618563co_pied
copper124321893copp_er
coppered153410543coppered
coppiced1734823coppiced
couped115019313coup_ed
couple104415963couple_
coupler114713013coupler
couples115317053couples
couplet114717943couplet
cowled125218393co_wled
crippled15336793crippled
cropped143812063cropp_ed
cupeled1257793cupeled
cupped134413983cupp_ed
dapped124516763dapp_ed
dapple1138853dapple_
dapples1238993dapples
dimpled132810303dimpled
dipped123517493dipp_ed
dogsled1035193dogsled
doiled84817293do_iled
doled75430913do__led
dolled83518073do_lled
doodled10369463doodled
doped95326713do_p_ed
doubled11289953doubled
doweled12269773doweled
dropped13329283dropp_ed
dupped124411643dupp_ed
empaled12288953empaled
fipple13329063fipple_
fipples14298653fipples
flopped15338763flopp_ed
foaled104515963fo_aled
foiled104618403fo_iled
fondled12399423fondled
fooled104317823fo_oled
footled113610763footled
foozled20346893foozled
fouled104315973fo_uled
fowled133914103fo_wled
gapped124217123gapp_ed
gipped124815903gipp_ed
glopped13347613glopp_ed
goaled85014363go_aled
gobbled134010253gobbled
goggled11348953goggled
grappled14336093grappled
gypped15377113gypp_ed
happed144820103happ_ed
hipped144317693hipp_ed
hirpled13157143hirpled
hobbled153310783hobbled
holed95634133ho__led
hondled123510653hondled
hooped125518183hoop_ed
hoped115628183ho_p_ed
hopper134218483hopp_er
hoppier143110703hoppier
hoveled14209293hoveled
howled134014973ho_wled
impaled12288513impaled
impled113812513_impled
joggled17398433joggled
jostled15267083jostled
jowled174210803jo_wled
kepped15309543kepp_ed
kipped153114573kipp_ed
knopped16355453knopp_ed
koppie14277883koppie_
koppies153210013koppies
lapeled10258893lapeled
lapped114320033lapp_ed
lipped114419543lipp_ed
loculed10317653loculed
lolled74315823lo_lled
looped95217173loop_ed
loped85128333lo_p_ed
lopper103717203lopp_er
loppered13326753loppered
loppier11369723loppier
louped95316383loup_ed
mapped134015883mapp_ed
mispled12310463mispled
mobled113213183mo_bled
modeled1139463modeled
moguled1135933moguled
moiled94318863mo_iled
moped105424733mo_p_ed
mopper126215003mopp_er
moppet126915093mopp_et
morphed1537133morphed
mottled10409973mottled
napped114218163napp_ed
nipped113615853nipp_ed
nipple103410373nipple_
nipples11319663nipples
nobbled123511283nobbled
noddled10358563noddled
noodled9339923noodled
nopales93812523nopales
ogled75915963_o_gled
oiled64429473_o_iled
oped76230153_o_p_ed
opened94311863_opened
opined95113853_opined
opposed1236123opposed
opted84914273_o_pted
outled74020343_outled
paddled123612023paddled
paled85538723__paled
palled94625163p_alled
palped114513643palp_ed
paneled10612573paneled
papered122513173papered
pappier103511593pappier
pappies103214823pappies
papule102212133papule_
papules112411573papules
parled94626293p_arled
paroled104217633paroled
pealed95322813p_ealed
pearled10411553pearled
pebbled1445403pebbled
pedaled113711893pedaled
peddled123410543peddled
peeled94119713p_eeled
peeped113915393peep_ed
people10310193people_
peopler1138083peopler
peoples11312223peoples
pepper93512943pepp_er
peppered1236133peppered
peppier10268323peppier
periled10316323periled
perplex1836153perplex
pestled102711453pestled
petaled103614153petaled
pettled103611513pettled
pickled164011883pickled
piddled123311253piddled
piffled16366403piffled
piled85232993__piled
pilled94222753p_illed
pimped134913483pimp_ed
pimple123512963pimple_
pimples133012423pimples
piped105123163p_ip_ed
pled75231433___pled
poached154212403poached
pocked154818983po_cked
podded115012713po_dded
poinded11358973poinded
pointed103813983pointed
poised94918473po_ised
poked125425393po__ked
pole65951303po__le_
poler74431793po__ler
poles75351003po__les
policed123212233policed
polkaed1435323polkaed
pollee83623273po_llee
pollen83416453po_llen
poller83921853po_ller
pollex153711163po_llex
polyped1537173polyped
pomaded13377863pomaded
pommeled1543103pommeled
ponced114314813po_nced
ponded105218773po_nded
ponged105619353po_nged
ponied94920703po_nied
pooched152810083pooched
poodle93112043poodle_
poodles103013513poodles
pooed85226243po__oed
poohed123912523po_ohed
pooler83819843po_oler
pope85535613po_p_e_
popeless1288473popeless
popes95933813po_p_es
poplar103611113po_plar
poplin10413483po_plin
popover1495843popover
poppa8409893popp__a
poppas93710713popp_as
poppers103414863poppers
poppets10338853poppets
popping113715413popping
poppling12227323poppling
poppy114813193popp__y
poppyhead1951503poppyhead
popsie103013053popsie_
popsies112816463popsies
popular11319563popular
populated14228803populated
pored85234513po__red
porked134717623po_rked
portaled11239203portaled
ported94223243po_rted
posed85828413po__sed
posited10511493posited
posole8314223posole_
posoles9314883posoles
posted93722493po_sted
potholed1448393potholed
potpie103412433potpie_
potpies113116173potpies
potted94624013po_tted
pottle84416103pottle_
pottles93816983pottles
pouched153612773pouched
poufed12449713po_ufed
pouffed16365953pouffed
pounced123510623pounced
pounded114112793pounded
poured95116743po_ured
pouted94021393po_uted
powered132911643powered
poxed154817863po__xed
pozole1758913pozole_
pozoles1839063pozoles
prepped11329903prepped
prilled104713003prilled
profiled14338523profiled
prompted1536903prompted
propelled1456913propelled
propined133111503propined
proponed132412033proponed
proposed132011073proposed
prowled13309913prowled
puddled123011193puddled
puled84926523__puled
pulled94322193p_ulled
pulped114612533pulp_ed
pumped133915563pump_ed
pungled114210083pungled
pupated12319353pupated
puppet93514593pupp_et
puppies103212613puppies
purfled13248733purfled
purled94520753p_urled
purple102712683purple_
purpler11289273purpler
purples112712833purples
puzzled18286653puzzled
rapped114122683rapp_ed
rappeled1335003rappeled
repled93319783_repled
repped114616723repp_ed
rimpled123311423rimpled
ripped114419013ripp_ed
ripple103413913ripple_
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
roiled74320053ro_iled
rolled74220243ro_lled
romped114513653romp_ed
rootled83410533rootled
roped84630803ro_p_ed
rouped95717353roup_ed
roweled11269863roweled
rumpled123810013rumpled
sampled123410793sampled
sapped114422013sapp_ed
sepaled10510593sepaled
shopped153512213shopp_ed
sipped113720633sipp_ed
slopped123511443slopp_ed
soaped95817973soap_ed
soiled73822473so_iled
soled65835173so__led
sopited104211063sopited
soppier112711583soppier
souled75419823so_uled
souped95017673soup_ed
sozzled16265183sozzled
spiled94621993_spiled
spoiled104811353spo_iled
spooled104613523spo_oled
stapled103613703stapled
stippled1345303stippled
stopped124512203stopp_ed
stopple1156583stopple_
stopples1236953stopples
supped114415703supp_ed
supple10410203supple_
suppler1148433suppler
supples11511283supples
supplied1345993supplied
swopped15437673swopp_ed
tapped113820053tapp_ed
templed12278563templed
tipped114418263tipp_ed
tipple103411913tipple_
tippler11348343tippler
tipples112811253tipples
toddled10328823toddled
toggled10428653toggled
toiled74420323to_iled
toled65934923to__led
tolled73819033to_lled
tooled74918903to_oled
tootled83511043tootled
toped85631313to_p_ed
topper103817603topp_er
totaled839693totaled
tousled84710363tousled
touzled17367153touzled
toweled112410223toweled
tripled104113833tripled
tupped114013233tupp_ed
unpiled102312743unpiled
upped103715163_upp_ed
uppiled12216593uppiled
voled95323723vo__led
wapped144416473wapp_ed
whopped18358003whopp_ed
wimpled15338823wimpled
wobbled15349593wobbled
wooled103715503wo_oled
woolled1136643woolled
woopsed1344733woopsed
yapped144415143yapp_ed
yipped143613283yipp_ed
yodeled1236863yodeled
yodled11389653yo_dled
yowled133811093yo_wled
zapped204213523zapp_ed
zipped203612983zipp_ed

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274077.11018850.5
3Display Results4074070.1562609.0
 (SQL Overall)1786914077.67223291.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.