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

419 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
purpler1128927(None) 
purfler12248731purfler
purple102712681purple_
purpled12299781purpled
purples112712831purples
burbler114412422burbler
burler84723832bur_ler
curdler103511562curdler
curler85221322cur_ler
furler93616402fur_ler
hurdler113610002hurdler
hurler94717222hur_ler
peopler1138082peopler
perplex1836152perplex
puddler112910752puddler
puler74826622pu__ler
puller83820812pu_ller
pulper103513272pulp_er
pulpier1148622pulpier
pumper124415552pump_er
purer75127902pur__er
purfle112511182purfle_
purfled13248732purfled
purflers13216962purflers
purfles122511842purfles
purger94717232pur_ger
purled94520752pur_led
purplest12249132purplest
purply13369052purpl_y
purpure1195992purpure
purser85020472pur_ser
pursier94012752pursier
pursuer9338892pursuer
purtier93214092purtier
puzzler17276962puzzler
suppler1148432suppler
turtler72610322turtler
ampler104313303_ampler
birler85715083bir_ler
bubbler103611783bubbler
buckler154112033buckler
bugler94717723bu_gler
bumbler134013233bumbler
bumper123714343bump_er
bumpier13359203bumpier
bundler104011723bundler
bungler104611483bungler
burble104617703burble_
burbled124312673burbled
burblers12399263burblers
burbles114916803burbles
burblier1255603burblier
burger94020793bur_ger
burgher1337003burgher
burglar1065533burglar
burgle94815863burgle_
burgled115511423burgled
burgles105615963burgles
burier84324653bur_ier
burker125221173bur_ker
burled94825383bur_led
burlers94120273bur_lers
burley114715753bur_ley
burlier93514413burlier
burner83819203bur_ner
burped116215503burp_ed
burrer83718473bur_rer
burrier93613553burrier
burster9310293burster
bustler94012563bustler
butler84220033bu_tler
caroler93816753caroler
carper104923633carp_er
circler1136423circler
coruler9311713coruler
coupler114713013coupler
crueler939023crueler
cruller968753cruller
crupper13338563crupper
cuddler113810743cuddler
culler84322253cu_ller
cupeler1177483cupeler
cupper124313863cu_pper
cuppier1368323cuppier
curber104517053cur_ber
curdier103312623curdier
curdle95514313curdle_
curdled113910663curdled
curdlers11368493curdlers
curdles103814573curdles
curer75030753cur__er
curled95021653cur_led
curlers94218073cur_lers
curlew114010903cur_lew
curlier93314183curlier
currier93316703currier
curser84721473cur_ser
curter85320083cur_ter
curule83614123curule_
curvier123110663curvier
cutler84718033cu_tler
dorper94314573dorp_er
dueler74213683du_eler
dueller8329833dueller
duller74017703du_ller
dumper114615213dump_er
dumpier12409653dumpier
duper85519003du_p_er
duple85315863du_ple_
duplex16386973du_plex
empurple1442183empurple_
empurpled1641323empurpled
empurples1542013empurples
fourplex2042093fourplex
fueler94313933fu_eler
fueller10279963fueller
fuller94220383fu_ller
fumbler143610813fumbler
funplex1932833funplex
furled104717053fur_led
furlers104214223fur_lers
furrier103513663furrier
further1337003further
furzier19318103furzier
garbler104012563garbler
gargler93710263gargler
girdler9227313girdler
grueler837023grueler
gulper93410213gulp_er
gulpier1046953gulpier
gurgle83912473gurgle_
gurgled10399123gurgled
gurgles94312873gurgles
gurglet94412033gurglet
guttler8369163guttler
guzzler16286563guzzler
harper115018403harp_er
hirple11158973hirple_
hirpled13157143hirpled
hirples12149643hirples
huddler12379423huddler
huller93919103hu_ller
humbler143411943humbler
humper134115883hump_er
humpier143110723humpier
hurdle103712793hurdle_
hurdled12379833hurdled
hurdlers12337493hurdlers
hurdles113613373hurdles
hurled104617453hur_led
hurlers103714323hur_lers
hurley125012523hur_ley
hurrier103412943hurrier
hurter93915853hur_ter
hurtle93512943hurtle_
hurtled11339593hurtled
hurtles103913753hurtles
hustler103410753hustler
juggler16418873juggler
jumbler183910273jumbler
jumper173612373jump_er
jumpier18317943jumpier
kruller1145153kruller
luller63415483lu_ller
lumper103816653lump_er
lumpier113410143lumpier
lurcher12338133lurcher
lurer54625313lur__er
lurker103613293lur_ker
marbler113511673marbler
muddler113411623muddler
muffler15398343muffler
muller83820353mu_ller
mumbler133510913mumbler
mumper123513523mump_er
muraled10410833muraled
murder93613783mur_der
murker123715243mur_ker
murkier133110273murkier
murther1237953murther
muzzler17257943muzzler
nurled74016233nur_led
nurser64314503nur_ser
nuzzler15296493nuzzler
paddler113711553paddler
paler75436933p__aler
pamper124316663pamp_er
paper95128663p_ap_er
pappier103511593pappier
parader103914863parader
pardner10239473pardner
parer75839903par__er
parker124121373par_ker
parle75836163par_le_
parled94626293par_led
parles86334403par_les
parley116718363par_ley
parlor8312673par_lor
parole84425253parole_
paroled104217633paroled
parolee94119643parolee
paroles95025883paroles
parrier93717653parrier
parser84822373par_ser
parsley1247803parsley
partier93520713partier
partlet92720363partlet
partner92811393partner
partyer12337873partyer
pauper103511943paup_er
pearler9310373pearler
pedaler103410693pedaler
peddler113210493peddler
pedler93614623p_edler
peeler83517383p_eeler
peeper103614803peep_er
people10310193people_
peopled1238503peopled
peoplers1237163peoplers
peoples11312223peoples
pepper93512943p_epper
peppier10268323peppier
percher143313423percher
periled10316323periled
peripter1278753peripter
perkier133813123perkier
perplexer2042753perplexer
perter84422283per_ter
peruser93511373peruser
piddler112911523piddler
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
pimplier1445413pimplier
piper96523193p_ip_er
pipier104913983p_ipier
plumper13318773plump_er
poler74431793p__oler
poller83921853p_oller
pooler83819843p_ooler
poplar103611113p_oplar
popper93615963p_opper
popple92710983popple_
poppled11339243poppled
popples103011873popples
porker124917543por_ker
porkier133712343porkier
pornier93413133pornier
porter84224413por_ter
portlier1038373portlier
pourer84516043pour__er
pourparler145983pourparler
prater84825353p_rater
prayer114815293p_rayer
prefer113813203p_refer
preyer114413733p_reyer
pricer103918293p_ricer
prier75027763p_r_ier
primer105118683p_rimer
prizer174714883p_rizer
prober104516073p_rober
prole74527793p_role_
proleg94612113p_roleg
proles84627203p_roles
proper104319953p_roper
proser84223463p_roser
prover113819723p_rover
prower114218123p_rower
prowler123310013prowler
pruner83413453p_runer
pryer104415313p_r_yer
pucker143817633pu_cker
puddle103914153puddle_
puddled123011193puddled
puddlers12298683puddlers
puddles113613823puddles
puddlier1234213puddlier
pudgier11377723pudgier
puerile9310093puerile_
puerpera1242853puerp_era
puffer144610733pu_ffer
puffier1547973puffier
puggier11309383puggier
pule65040953pu__le_
puled84926523pu__led
pulers83820283pu__lers
pules74538813pu__les
pulled94322193pu_lled
pullers93618483pu_llers
pullet84026333pu_llet
pulley113713403pu_lley
pulped114612533pulp_ed
pulpers114612283pulp_ers
pulpless12224953pulpless
pulser84215193pu_lser
pumicer1335063pumicer
pumped133915563pump_ed
pumpers133113673pump_ers
pumpless14236373pumpless
puncher143311673puncher
pungle94413573pungle_
pungled114210083pungled
pungles104013713pungles
punier84519223pu_nier
punker123718823pu_nker
punkier133512793punkier
punner84918153pu_nner
punnier93511263punnier
punster92911103punster
punter84320023pu_nter
pupae96515643pu_pae_
pupilar11125313pupilar
pupped105013273pu_pped
puppet93514593pu_ppet
puppies103212613puppies
pure65543333pur__e_
puree74632843pur__ee
pureed95017813pur_eed
purees84721683pur_ees
purely114013633purel_y
purge85324603pur_ge_
purged104918263pur_ged
purgers104714003pur_gers
purges94421763pur_ges
purifier1338573purifier
purine85321893purine_
purines94420763purines
purl65631423pur_l__
purlieu938143purlieu
purlin83615863pur_lin
purls74723353pur_l_s
purpling1368543purpling
purplish1554933purplish
purport1159393purport
purpose1137383purpose
purposed1335263purposed
purposes1237823purposes
purpura1144793purpura
purpures1276143purpures
purr64925813pur___r
purred94218073pur_red
purse76028893pur_se_
pursed95220883pur_sed
pursers93916093pur_sers
purses84826373pur_ses
pursue84512253pursue_
pursued10388133pursued
pursuers10376523pursuers
pursues94111373pursues
purulent1047613purulent
purvey14559573pur_vey
purview1534233purview
pusher114318283pu_sher
pushier123611093pushier
pusley11379613pu_sley
pussier93711993pussier
pussley12375123pussley
putter83921443pu_tter
puttier93314503puttier
puzzle16318603puzzle_
puzzled18286653puzzled
puzzlers18295143puzzlers
puzzles17318973puzzles
queller16289293queller
quipper2095823quipper
rippler113210103rippler
ruffler13369723ruffler
ruler54923343__ruler
rumbler113514113rumbler
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
rumplier1235303rumplier
rustler73512343rustler
sampler113212013sampler
simpler112910863simpler
sparkler14317983sparkler
spurner9269653spur_ner
spurrer93710223spur_rer
spurrier10297693spurrier
spurter94013003spur_ter
spurtle937453spurtle_
spurtles1037783spurtles
stapler93913633stapler
subtler92910843subtler
suckler133413093suckler
sumpter1138873sumpter
super74924483su_p_er
supper104115433su_pper
supple10410203supple_
suppled1248463suppled
supples11511283supples
supplier1246603supplier
surer54833103sur__er
surfer93515883sur_fer
surfier102613543surfier
surger74320093sur_ger
surlier72915443surlier
surplus936793surplus
sutler63718393su_tler
tippler11348343tippler
tumbler113412823tumbler
tummler11266613tummler
turfier10249793turfier
turner63914613tur_ner
turtle63213573turtle_
turtled8309683turtled
turtlers8258203turtlers
turtles72914343turtles
upper93714263_u_pper
upriser9218763upriser
upriver12196933upriver
ureter6313203_ureter
urger64116473_ur_ger
urped84615283_urp_ed
usurper934353usurp_er
warbler123211463warbler
warper114015583warp_er
warsler10289893warsler

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.390458182.1
2DLD Change Limit1340274196.67320085.0
3Display Results4194190.1562685.9
 (SQL Overall)1786914197.21924752.9
 
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.