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

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

55 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
priority134744(None) 
apriority1444741apriority
piosity1268642p_iosity
priorate10411732priorate
priories10312452priories
priorly12335762prior_ly
priory114110262prior__y
privity15268312pri_vity
probity14299682pr_obity
aridity11510113ari_dity
cariosity1446213cariosity
curiosity1444543curiosity
diorite8314913_diorite
frivolity1843063frivolity
juniority1943113juniority
majority2044663majority
minority1347933minority
otiosity1155763otiosity
parity114719873p__arity
picrite111911313p_icrite
pilosity1366323pilosity
polarity131310403polarity
polity113015863p__olity
porosity1348593porosity
preciosity1754633preciosity
precocity1845913precocity
pricily142710283pri_cily
primality1687333primality
primarily1644673primarily
prior74316173prior___
priorates11410763priorates
prioress1035393prioress
priorities1249153priorities
prioritize2154253prioritize
priors83914483prior__s
prissily1346693prissily
privily15207623pri_vily
probit103218353pr_obit_
probits112712573pr_obits
prodigy1435573pr_odigy
profit113016273pr_ofit_
profits122911243pr_ofits
propriety1645433propriety
prorate9418733pr_orate
prosily12611633pr_osily
prosit85124593pr_osit_
purity114114913p__urity
rarity93615493_r_arity
rimosity1345713_rimosity
seniority1246393seniority
sonority1148533sonority
sorority1146903sorority
superiority1655863superiority
trinity10310843tri_nity
triunity1145073triunity

Search took 10 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.423422437.4
2DLD Change Limit146162558.89016441.2
3Display Results55550.0163437.5
 (SQL Overall)178691559.32919154.4
 
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.