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 “peeper” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
peeper10361480(None) 
beeper103714091beeper
deeper93613501deeper
keeper123811911keeper
peeler83517381peeler
peeped113915381peeped
peepers113713671peepers
pepper93512941pepper
weeper114313301weeper
beeped115313452beeped
beepers113612382beepers
beezer174010522beezer
bleeper11458252bleeper
cheeper143610742cheeper
creeper11339972creeper
deepen9339192deepen
feeder103513842feeder
feeler93215172feeler
geezer16278012geezer
heaper114119522heaper
heeder104216042heeder
heeler93917312heeler
helper114313092helper
hepper133412662hepper
jeeped16469842jeeped
jeepers16399192jeepers
jeerer13389932jeerer
keener104012832keener
keepers133410982keepers
leaper88118942leaper
leper74820742_leper
meeker12359982meeker
meeter83616502meeter
needer73614952needer
pamper124316662pamper
paper95128662p_aper
pauper103511942pauper
pecker144615362pecker
pedler93614612pedler
peeked134314572peeked
peeled94119702peeled
peelers93615592peelers
peened94318152peened
peep85833692peep__
peeps95822362peep_s
peepul1035782peepul
peer66238352p_e_er
peered93819482peered
peeve104915252peeve_
peeved124112882peeved
peeves113814872peeves
peewee11311962peewee
pelter83321622pelter
penner84616662penner
peopler1138072peopler
pepped103113392pepped
peppers103311442peppers
peppery13286242peppery
peppier10268322peppier
perter84422282perter
pester84827592pester
peter74427592p_eter
petter83924772petter
pewter114013672pewter
piecer105213082piecer
piper96523192p_iper
popper93615962popper
preener93114832preener
prefer113813202prefer
preyer114413732preyer
proper104319952proper
pulper103513272pulper
pumper124415552pumper
reaper84223142reaper
reefer93314362reefer
reeker103715592reeker
reeler63822572reeler
seeder74320772seeder
seeker103615362seeker
seemer84418042seemer
seeped94317522seeped
seepier92912012seepier
sleeper93211562sleeper
speeder103811072speeder
steeper93812772steeper
sweeper12329372sweeper
teemer85515742teemer
teener64717502teener
teepee8314362teepee
teeter65420312teeter
temper103914092temper
veepee11311482veepee
vesper1138082vesper
weeder103315512weeder
weepers123511972weepers
weepier12319272weepier
weever123811442weever
yelper11458782yelper

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551982.65631080.9
3Display Results98980.0332969.7
 (SQL Overall)178691982.79963841.0
 
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.