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

229 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
prier7502776(None) 
brier74527401brier
crier74724461crier
drier64423961drier
frier85225841frier
pier66035291p_ier
plier75221281plier
pricer103918291pricer
pried84426861pried
priers84521191priers
pries74339531pries
primer105118681primer
prior74316171prior
prizer174714881prizer
pryer104415311pryer
sprier84119061sprier
trier54328531trier
wrier84521751wrier
aerier64823152aerier
airer54927892airer
airier64619362airier
arider74717742arider
ariel55228972ariel
armer76924442armer
artier63419732artier
bier65531832_bier
briar75718152briar
briber104714052briber
brie65837902brie_
brief105422602brief
briers85319732briers
briery114510772briery
bries74942152bries
briner84519042briner
burier84324652burier
cried84624282cried
criers83918582criers
cries75438402cries
direr64927072direr
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
dryer95111462dryer
eerier64320022eerier
firer811229252firer
flier86023402flier
freer86021242freer
friar85414272friar
fried95322912fried
friers94718932friers
fries85535602fries
frizer184011282frizer
fryer115913432fryer
gorier73719372gorier
grief95319782grief
griper94114612griper
hirer85423122hirer
icier74313752icier
kier86526812_kier
lier45942462_lier
mirier83918362mirier
orbier839992orbier
order65019362order
oriel54920422oriel
ormer75218372ormer
osier53518012osier
pacer96131612pacer
pacier105018682pacier
pager84728202pager
pair66031512pai_r
paler75436932paler
palier85023562palier
panier84425502panier
paper95128662paper
parer75839902parer
paries84742512paries
parker124121372parker
parrier93717652parrier
parser84822372parser
partier93520712partier
pater74740722pater
paver104225832paver
pawer104422972pawer
payer105125722payer
peer66238352p_eer
per56353092p__er
perkier133813122perkier
perter84422282perter
peter74427592peter
pie55457402p_ie_
pied75035362p_ied
piers75926332p_iers
pies66949602p_ies
piker115622842piker
pinier84024692pinier
piper96523192piper
pipier104913982pipier
pitier84019822pitier
plie65127392plie_
plied85118592plied
pliers84715152pliers
plies74526512plies
plyer106214332plyer
poiser84217242poiser
poker115122882poker
pokier124914632pokier
poler74431792poler
porker124917542porker
porkier133712342porkier
pornier93413132pornier
porter84224412porter
poser75128772poser
power105325952power
poxier153812112poxier
praiser93413942praiser
prater84825352prater
prayer114815292prayer
pree67044732pr_ee
preed85128122preed
preen75925052preen
prees75937172prees
prefer113813202prefer
premier113515632premier
prep86427672pr_ep
prex135722972pr_ex
prey96228482pr_ey
preyer114413732preyer
prez156126312pr_ez
price93725412price
priced115018882priced
pricers113915062pricers
prices104524542prices
pricey134412632pricey
pricier113313112pricier
prick134317502prick
pricker154013412pricker
pricy124814562pricy
pride84724732pride
prided103618032prided
prides94324182prides
priest84125422priest
prig75924872pri_g
prigs85219702prigs
prill74117942prill
prim85132202pri_m
prima95019342prima
prime96525602prime
primed115118912primed
primero11368922primero
primers114215672primers
primes104225262primes
primi95017402primi
primmer134310162primmer
primo95017912primo
primp115615922primp
prims95425932prims
prink114719672prink
prinker133412742prinker
print74837462print
printer93917302printer
prion75119992prion
priors83914482priors
priory114110262priory
prise74632612prise
prised94322202prised
prisere9310942prisere
prises84133172prises
prism94820262prism
priss74623892priss
privet113821342privet
privier122910452privier
privy13439832privy
prize164718942prize
prized184415392prized
prizers183911842prizers
prizes173819812prizes
prober104516072prober
proem94818272proem
proper104319952proper
proser84223462proser
prosier93817482prosier
prover113819722prover
prower114218122prower
pruner83413452pruner
pryers115012242pryers
puler74826622puler
punier84519222punier
purer75127902purer
purger94717232purger
purser85020472purser
pursier94012752pursier
purtier93214092purtier
ricer74726612_ricer
rider65231302_rider
riel46432382_riel
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
river85731692_river
ruer46127562_ruer
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
spirier93214072spirier
spryer11418532spryer
tier44936142_tier
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
twier84713292twier
upriser9218762upriser
upriver12196932upriver
urger64116472urger
varier94619352varier
verier94620962verier
vier75428152_vier
warier93722892warier
wirer85124952wirer
wirier94215552wirier
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer

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 Filter178691538000.296603685.8
2DLD Change Limit538002291.68631909.8
3Display Results2292290.0633634.9
 (SQL Overall)1786912292.04587379.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.