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

196 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
priories1031245(None) 
armories10313652armories
brionies10310542brionies
friaries11310082friaries
pirogies1139422pirogies
prairies10411452prairies
predries112714382predries
primaries13410832primaries
priorates11410762priorates
prioress1035392prioress
priorities1249152priorities
priority1347442priority
priors83914482prior__s
prissies101712002prissies
privies122414262pri_vies
proxies163014932pr_oxies
apiaries10312723apiaries
apriorities1345403apriorities
apriority1444743apriority
arbores94016033arbor_es
arborizes2088823arborizes
argosies939523argosies
armoires1057623armoires
armouries1146243armouries
arteries8321483arteries
aviaries1139783aviaries
briberies1348333briberies
brinies93317913bri_nies
brioches15227253brioches
brookies1459143brookies
bryonies1336843bryonies
calories102919553calories
chicories1688763chicories
cronies9622503cr_onies
crores86121163cr_or_es
dairies84217733dai_ries
diaries83321953_diaries
diorites9313523_diorites
dories75232363__dories
drearies92313413drearies
fairies103516043fai_ries
frizzies19315933frizzies
glories81915913_glories
grigris934093grigri_s
idiocies1145223idiocies
ironies7517423ir_onies
ivories10310713_ivories
lories64933043__lories
memories121214353memories
oratories9410643oratories
orioles7412993orio_les
orreries8310123orreries
panfries13149203panfries
pantries101817393pantries
paries84742513p__aries
parities10522973pari_ties
parodies11313693parodies
parries93925843p_arries
pastries101517423pastries
peeries93623023p_eeries
pelorias10410593pelorias
peltries10313023peltries
penuries10311663penuries
peonies93620153p_eonies
periodids1345643periodids
perjuries1846493perjuries
perries93226603p_erries
phonies123717513p_honies
phratries1447583phratries
picrites121811083p_icrites
pierces113411193p_ierces
pieties9419223p_ieties
piggies113813483p_iggies
pigmies122610993p_igmies
pillories1189573pillories
pineries102419083pineries
pinkies133818263p_inkies
pinnies93318443p_innies
piracies12312643piracies
pirogues1135473pirogues
piroques1944353piroques
pities83828083p_i_ties
pixies154915513p_i_xies
pliskies1475973pliskies
ploidies1138173ploidies
poetries10315583poetries
pogies94123543p__ogies
pokies125921333p__okies
polies84034583p__olies
ponies84833463p__onies
pooris83916843p_oori_s
poperies12316793poperies
pores75849033p__or_es
porgies103017003p__orgies
porkies133416493p__orkies
posies84431433p__osies
prairie938333prairie_
predried12309573predried
preemies12512193preemies
prefires134313283prefires
premies113823063pr_emies
preorder1136463preorder
preorders1235403preorders
preppies1149683preppies
preprices1569263preprices
pretrims1238983pretrims
pretties10615133pretties
prewires133811013prewires
prexies163415003pr_exies
prices104524543pri__ces
pricier113313113pri_cier
priciest122112903pri_ciest
prickier16368143prickier
prickiest1748183prickiest
prickles162511093prickles
prides94324183pri__des
priedieu1153983priedieu
priedieus1242943priedieus
priers84521193prier__s
pries74339533p___ries
priggeries1444993priggeries
primacies1548453primacies
primages13159273primages
primates121515933primates
primes104225263pri__mes
primines123013703primines
primrose1244503primrose
primroses1344843primroses
primsie1137543primsie_
primuses1237083primuses
princes113015143pri_nces
printeries12410633printeries
prions84317783prio__ns
prior74316173prior___
priorate10411733priorate
prioresses1245703prioresses
prioritizes2254273prioritizes
priorly12335763prior_ly
priorships1755393priorships
priory114110263prior__y
priseres10310823priseres
prises84133173pri__ses
prisses94816713pri_sses
prissier10157873prissier
prissiest11178903prissiest
privacies1646803privacies
privates131812373privates
privier122910453pri_vier
priviest132310313pri_viest
privities14312043privities
prizes173819813pri__zes
probes104119453pr_o_bes
probits112712573pr_obits
profiles133211233pr_ofiles
profits122911243pr_ofits
proles84627203pr_o_les
prolines102619693pr_olines
promines123018803pr_omines
promise113415843pr_omise
promises122916763pr_omises
propines122618933pr_opines
prorates10418073pr_orates
proses84733473pr_o_ses
prosier93817483pr_osier
prosiest10416523pr_osiest
prosodies1249733prosodies
prosses94019513pr_osses
prossies101515223prossies
prosties101421193prosties
proves114322253pr_o_ves
provides1439883pr_ovides
pruderies1247873pruderies
puggries12166383puggries
purifies13311923puri_fies
purities10316283puri_ties
redries83721713_redries
refries104419733_refries
retries74129073_retries
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
savories11311273savories
stories7324273_stories
theories11311593theories
tories65435883__tories
tricornes1146233tricornes
trilbies1037693trilbies
trilogies1048173trilogies
triodes84012503trio_des
trioses75015653trio_ses
trioxides1744483trioxides
trioxids1644443trioxids
tripodies1246573tripodies
trisomies1147163trisomies
urinaries949203urinaries
whirries14136693whirries

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.436409841.7
2DLD Change Limit1461621967.45319611.2
3Display Results1961960.0802450.0
 (SQL Overall)1786911967.96922423.3
 
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.