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

135 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
privity1526831(None) 
privily15207621privily
aridity11510112aridity
brevity1534782brevity
gravity1437182gravity
pricily142710282pricily
priority1347442priority
privacy1744232privacy
private121513262private
privet113821342privet_
privets122910052privets
privier122910452privier
privies122414262privies
privy13439832priv__y
probity14299682probity
trinity10310842trinity
ability12311443ability
acidity1338593acidity
acridity1446913acridity
activity1647583activity
agility1148653agility
aminity12310513aminity
anility10312723anility
apriority1444743apriority
avidity1436483avidity
captivity1944673captivity
cavity14310013_cavity
criminy14268453criminy
crinite9513633crinite
crudity1336043crudity
depravity1842793depravity
dimity12310473_dimity
drifty13418223dri_fty
driving123910713driving
erosivity1544483erosivity
fixity19427803_fixity
frivolity1843063frivolity
fruity12429693fr_uity
grimily1336523grimily
gritty10338403gri_tty
grivet103517823grivet_
grivets11357973grivets
levity1277903_levity
motivity1646223motivity
naivety1344283naivety
nativity1446633nativity
orality101111683orality
painty114714753pai_nty
parity114719873p_arity
passivity1744093passivity
paucity1435823paucity
peripety1546193peripety
piety105817303p_i_ety
pigsty1235933p_igsty
pinite8321243p_inite
piosity1268643piosity
pipit95224873p_ipit_
pipits104713063p_ipits
pity96031933p___ity
pivot106523873p_ivot_
pivots115111903p_ivots
pointy114913283poi_nty
polity113015863p_olity
porosity1348593porosity
preinvite1485443preinvite
pretty11510873pr_etty
preview1536473preview
previse123713793previse
pricey134412633pri_cey
pricier113313113pricier
pricing123417343pricing
prickly18367893prickly
pricky174210343pri_cky
pricy124814563pr__icy
priding113317543priding
priest84125423priest_
priestly1345843priestly
priests93810863priests
primacy1635603primacy
primality1687333primality
primary1437703primary
primate111516283primate
primely1457723primely
primi95017403primi__
primine113214823primine
priming123417373priming
primly13439623pri_mly
print74837463pri_nt_
prints84320103pri_nts
priorly12335763priorly
priory114110263pri_ory
prising103321453prising
prissily1346693prissily
prissy11347853pri_ssy
privately1744893privately
privater13158533privater
privates131812373privates
priviest132310313priviest
privities14312043privities
prizing193514683prizing
probit103218353probit_
probits112712573probits
proclivity2053663proclivity
prodigy1435573prodigy
profit113016273profit_
profits122911243profits
prolixity2144863prolixity
prosily12611633prosily
prosit85124593prosit_
provide1339853provide
proving134214073proving
proviso1237313proviso
proximity2344673proximity
puerility1445993puerility
purity114114913p_urity
putridity1544193putridity
rarity93615493_rarity
righty135011833_righty
rivet85636363_rivet_
rivets94417113_rivets
riving104521423_riving
shiviti1344863shiviti
suavity1336313suavity
trilith10310513trilith
triunity1145073triunity
trivet93721883trivet_
trivets103911583trivets
trivia938503trivi_a
trivial1038713trivial
trivium1256143trivium
utility1038703utility
viridity1545903viridity
virility1447733virility
vivify1834703_vivify
wristy12509703wri_sty

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271357.36018210.2
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.82922824.2
 
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.