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

295 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
peoplers123716(None) 
peopler1138081peopler_
peoples11312221people_s
pearlers1039032pearlers
pedalers11239392pedalers
peddlers12298532peddlers
pedlers103013272pe_dlers
peelers93615592pe_elers
peepers113713672peep_ers
people10310192people__
peopled1238502people_d
peppers103311442pe_ppers
polers84225642p_o_lers
pollers93420022p_ollers
poolers94217422p_oolers
poplars113910332p_oplars
poppers103414862p_oppers
propers113619032prop_ers
prowlers13328932prowlers
adopters1136693adopters
beboppers1742323beboppers
beepers113612383beep_ers
beetlers1037393beetlers
befoulers1443123befoulers
bevelers13389453bevelers
boilers93417063_boilers
boodlers113710743boodlers
boppers133911923_boppers
bowlers123715783_bowlers
broilers103210093broilers
ceilers93912533ce_ilers
cholers124215203cho_lers
choppers174110463choppers
coalers94419353_coalers
coilers93619903_coilers
coolers93522493_coolers
coopers114019483coop_ers
copers104629843_cop_ers
copiers114215963_copiers
coppers133519753_coppers
copters113621283_copters
couplers123311323couplers
cropless1237793cropless
croppers143311483croppers
dealers84118613de_alers
decouplers1573083decouplers
defilers12439473defilers
depeoples1444223depeople_s
deposers11359243deposers
diopters1137693diopters
doodlers10338843doodlers
dopers95522483_dop_ers
droplets1136063droplets
droppers13318603droppers
elopers95112943elop_ers
empalers12226743_empalers
epopees1137233epop_ees
exilers14419733_exilers
feelers103814743fe_elers
fellers104117543fe_llers
feoffers1333133feoffers
floppers15337463floppers
footlers113910793footlers
foozlers20346073foozlers
fowlers133411203_fowlers
gaolers83511563gao_lers
gophers1338983_gophers
gropers104813853grop_ers
growlers12327093growlers
healers104319463he_alers
heapers123616673heap_ers
hecklers17357123hecklers
heelers103815623he_elers
hellers103619833he_llers
helpers123311853help_ers
helpless1335063helpless
hollers103818233_hollers
hoopers123616483hoop_ers
hoopless13279263hoopless
hopers114222973_hop_ers
hoppers143115143_hoppers
howlers133312353_howlers
jeepers16399193jeep_ers
jewelers1834713jewelers
keepers133410983keep_ers
kegelers1355163kegelers
keglers12277773ke_glers
knollers12255143knollers
leapers93716663leap_ers
lepers84817323le_p_ers
levelers11259323levelers
lollers72713793_lollers
loopers93914033loop_ers
lopers84424143_lop_ers
loppers113014103_loppers
meddlers12318203meddlers
mewlers12288983me_wlers
moilers93615203_moilers
mopers104220373_mop_ers
moppers133412463_moppers
needlers9287423needlers
nestlers8359223nestlers
nettlers8307513nettlers
oglers74313183__oglers
oilers64721193__oilers
paddlers12329153paddlers
pampers133615933pamp_ers
papers105125323p_ap_ers
paupers114311073paup_ers
peachers153213843peachers
peakless14236683peakless
pearler9310373pearler_
pebbles1337573pebble_s
peckers153312673pe_ckers
pedaler103410693pedaler_
pedalfers1542903pedalfers
pedaliers1245183pedaliers
pedallers1244763pedallers
peddler113210493peddler_
peddlery15224013peddlery
peddles112913703peddle_s
pedlars103210213pe_dlars
pedler93614623pe_dler_
pedlery13297083pe_dlery
peeler83517383pe_eler_
peeper103614803peep_er_
peerless1037513peerless
peers75130273pe___ers
pegless1038053pe_gless
peles75738083pe__le_s
pellets94014783pe_llets
pelters93720313pe_lters
peltless10267373peltless
pencilers1345643pencilers
penners93414183pe_nners
pensters103012123pensters
peones83821043peo_ne_s
peonies93620153peonie_s
peopleless1441913peopleless
peopling1338353peopling
peplos101211543pe_pl_os
peplums13145503pe_plums
peplus10138343pe_pl_us
pepper93512943pe_pper_
pepperers1244903pepperers
peppery13286253pe_ppery
peppier10268323peppier_
perchers153611523perchers
peripters1368123peripters
perplex1836153perple_x
perplexers2142333perplexers
perplexes2044683perplexes
perusers10328803perusers
pesters93827093pe_sters
pestles93217693pestle_s
peters86624593pe__ters
petters93722363pe_tters
pettles93916483pettle_s
pewters124113353pe_wters
piddlers12359593piddlers
pimples133012423pimple_s
piolets93513193pio_lets
pioneers1035863pioneers
pipers104318663p_ip_ers
plodders1235523plodders
plotless10256793plotless
plotters104011553plotters
plovers123611833plo_vers
plowers123812243plo_wers
poetless1038723poetless
poisers94214433p_oisers
pokers124617923p_o_kers
polars84419353p_o_lars
polders103617373p_olders
poleis86018353p_o_leis
poler74431793p_o_ler_
poles75351003p_o_le_s
pollees93215333p_ollees
pollens93713303p_ollens
poller83921853p_oller_
ponders103618843p_onders
poodles103013513poodle_s
poofters1336923poofters
pooler83819843p_ooler_
popeless1288473p_opeless
popery134511703p_op_ery
popes95933813p_op_e_s
poplar103611113p_oplar_
poplins11313153p_oplins
popovers1595663p_opovers
popper93615963p_opper_
poppets10338853p_oppets
popples103011873popple_s
porkers134314933p_orkers
porters93722703p_orters
posers84223973p_o_sers
posters93928013p_osters
pothers123818623p_others
potters94024343p_otters
potzers184010543p_otzers
poulters103911053p_oulters
pourers93513673p_ourers
pouters94221873p_outers
powders134111553p_owders
powers113822323p_o_wers
powters124015663p_owters
preorders1235403preorders
probers113514583pro_bers
problems1434343problems
prodders1237463prodders
proffers16126593proffers
profilers14236293profilers
proggers12258163proggers
prolegs10379993pro_legs
proles84627203pro_le_s
prompters1537553prompters
proofers13118363proofers
propellers1455203propellers
propels113412843prop_els
proper104319953prop_er_
prophets1539503prophets
propjets1935493propjets
proposers13228523proposers
prosers94219643pro_sers
prospers123012263prospers
provers123817793pro_vers
prowler123310013prowler_
puddlers12298683puddlers
pulers83820283p__ulers
pullers93618483p_ullers
pulpers114612283pulp_ers
pulpless12224953pulpless
pumpers133113673pump_ers
pumpless14236373pumpless
purflers13216963purflers
purpler11289273purpler_
purples112712833purple_s
puzzlers18295143puzzlers
reapers93520453reap_ers
recoilers11318153recoilers
reelers73520273re_elers
regalers94311133regalers
reoffers1434693reoffers
reopens939373reop_ens
reorders9198833reorders
repeoples1345413repeople_s
repliers103710163re_pliers
reposers102911603reposers
repowers13288533repowers
rerollers9207123rerollers
revelers113414133revelers
revilers114011693revilers
ripplers12337113ripplers
rollers73117473_rollers
ropers84325903_rop_ers
samplers12299403samplers
scowlers13257373scowlers
sealers74323553se_alers
sellers73721313se_llers
settlers8289023settlers
shoppers153010763shoppers
slopers94213093slop_ers
spellers102812753spe_llers
spoilers10238633spoilers
spoolers10349363spoolers
staplers103111203staplers
stopers94217373stop_ers
stoppers123910593stoppers
tellers73717593te_llers
telphers1335473telphers
tempers113513013temp_ers
templars1255263templars
temples112610893temple_s
templets12226143templets
tempters12257293tempters
tipplers12336353tipplers
toilers74116263_toilers
tollers73217463_tollers
toolers74416503_toolers
tootlers8289503tootlers
topers85025323_top_ers
topless92511123_topless
toppers113914603_toppers
trollers83211213trollers
unpeoples1343503unpeople_s
vealers103214293ve_alers
veilers103911823ve_ilers
vespers1239033vesp_ers
weepers123511973weep_ers
whoppers18297533whoppers
woolers104214023_woolers
yellers103912953ye_llers
yelpers12348203yelp_ers
yodlers11298923_yodlers
yowlers13328923_yowlers

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622956.83021400.0
3Display Results2952950.1062783.0
 (SQL Overall)1786912957.35624291.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.