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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
peery10571944(None) 
beery105220121beery
eery76129621_eery
leery85919131leery
peer66238351peer_
peers75130271peers
perry105222711perry
veery115816251veery
aery77231682_aery
apery106517902apery
beefy135313832beefy
beer65635992beer_
beers75628392beers
berry104521772berry
celery1139622celery
cheery144913152cheery
deary95826842deary
decry115514352decry
deedy104315892deedy
deer56739022deer_
deers64930522deers
derry94721372derry
eely77725212_eely
emery104814332emery
every115215452every
eyry106315882_eyry
faery116015482faery
ferry116020802ferry
fiery114714792fiery
geeky134710732geeky
henry114014472henry
herry114922472herry
jeer115426462jeer_
jeers124818132jeers
jerry155016182jerry
kerry124916092kerry
leary85927382leary
leer46239352leer_
leers54828982leers
merry104721482merry
needy94614692needy
onery8414122onery
papery134812742papery
parry105323752parry
peaky145718152peaky
pear69745232pear_
pearl75324462pearl
pearly116414842pearly
pears75138612pears
peart76440752peart
peaty105725692peaty
peavy135014842peavy
pecky165515092pecky
pedlery13297082pedlery
pedro8313152pedro
pee56066512pee__
peed76239182pee_d
peek106031432pee_k
peeks115021112peeks
peel65535612pee_l
peels75226422peels
peen65938082pee_n
peens76428192peens
peep85833692pee_p
peeps95822362peeps
peered93819492peered
peerie83617892peerie
pees65257372pee_s
peeve104915252peeve
peltry11288652peltry
penny105119452penny
penury1148102penury
peony105717562peony
peppery13286252peppery
peppy114310362peppy
per56353092p_er_
perdy115417332perdy
pere66450262p_ere
perea75026442perea
peres76246642peres
peri65636972p_eri
perk106232842p_erk
perky145319482perky
perm85834632p_erm
perp89029892p_erp
pert66759322p_ert
perv97224812p_erv
pesky145911562pesky
pesty106421712pesty
peter74427592peter_
peters86624592peters
petty105320292petty
pier66035292pier_
piers75926332piers
piety105817302piety
pinery115214292pinery
poesy105014062poesy
poetry1139382poetry
popery134511702popery
predry1237872predry
prexy174611582prexy
prey96228482pre_y
pry85728052p__ry
query174212082query
redry94314362redry
reedy910020292reedy
reefy114217702reefy
reeky125416262reeky
refry114412462refry
retry84718082retry
revery124014212revery
seedy94821532seedy
seely84522632seely
seepy104717972seepy
seer45547042seer_
seers55136382seers
serry84824122serry
sneery93610412sneery
speedy1218410792speedy
speer74623902speer_
speers85019952speers
sphery14318882sphery
teary85124052teary
teeny85417882teeny
terry84721872terry
veer76229572veer_
veers84521362veers
venery123710662venery
very108025642_very
weary115620612weary
weedy125115002weedy
weeny115316162weeny
weepy134212592weepy
weer75535092weer_

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001341.42337807.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911341.782100275.5
 
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.