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

123 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
prioress103539(None) 
prepress12137972prepress
primness1276762primness
princess12266802princess
prioresses1245702prioresses
priories10312452priories
priors83914482prior__s
process11310402pr_ocess
profess1237712pr_ofess
progress1137022progress
prowess1237902pr_owess
arbitress1143853arbitress
arbores94016033arbore_s
aridness939223aridness
armorers10288963armorers
armorless1143483armorless
brimless1235273brimless
crores86121163cr_ore_s
digress938323_digress
dripless1135243dripless
editress944933editress
errorless942813errorless
grimness1175993grimness
heiress1036813hei_ress
lioness739103_lioness
mayoress1344383mayoress
oratress834553oratress
orioles7412993oriole_s
painless10108343painless
peeress939503p_eeress
phoresy1534653p_horesy
piolets93513193p_iolets
poitrels1035243poitrels
poorest9312773p_oorest
poorness1036353p_oorness
pores75849033p__ore_s
porteress1137923porteress
portress1038313portress
prebless1236823prebless
precess11310863pr_ecess
preorders1235403preorders
prepregs13144763prepregs
press75425953p___ress
prestress1138133prestress
priceless1336883priceless
pricers113915063pri_cers
prices104524543pri_ce_s
priciest122112903priciest
prickers163710673prickers
prickets16329083prickets
prides94324183pri_de_s
priers84521193pri__ers
pries74339533pri__e_s
priest84125423pri__est
priestess1145293priestess
priests93810863pri__ests
primeness1338653primeness
primeros12336883primeros
primers114215673pri_mers
primes104225263pri_me_s
primmest14226693primmest
primrose1244503primrose
primroses1344843primroses
primuses1237083primuses
princes113015143prince_s
princesse13264403princesse
prinkers143010383prinkers
printers103214903printers
printless1137513printless
prions84317783prio__ns
prior74316173prior___
priorate10411733priorate
priorates11410753priorates
priority1347443priority
priorly12335763prior_ly
priory114110263prior__y
priseres10310823priseres
prises84133173pri_se_s
prisoners1147373prisoners
priss74623893pri___ss
prisses94816713prisse_s
privets122910053pri_vets
privies122414263privie_s
priviest132310313priviest
prizers183911843pri_zers
prizes173819813pri_ze_s
probers113514573pr_obers
probes104119453pr_obe_s
procuress1344093procuress
proems104711163pr_o_ems
projets1639163pr_ojets
prolegs10379993pr_olegs
proles84627203pr_ole_s
proofers13118363proofers
propels113412843pr_opels
propers113619033pr_opers
prosers94219643pr_osers
proses84733473pr_ose_s
pross76529403pr_o__ss
prosses94019513pr_osses
proteas92015123pr_oteas
protest9317533pr_otest
protests10310483pr_otests
proteus92511593pr_oteus
provers123817793pr_overs
proves114322253pr_ove_s
prowest12311533pr_owest
redress82511873_redress
regress82711453_regress
repress92712683_repress
ribless93410343_ribless
rimless9369363_rimless
rioters73615503_rioters
tigress836093_tigress
traitoress1043613traitoress
traitress944403traitress
trigness968403trigness
trimness1067563trimness
triodes84012503triode_s
triolets83410143triolets
trioses75015653triose_s
tutoress845093tutoress
waitress1135223waitress

Search took 9 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.186960704.3
2DLD Change Limit1461621238.37617450.1
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.60820758.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.