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

67 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
privacy174423(None) 
primacy1635601primacy
piracy1339472p_iracy
prelacy1437582prelacy
pricy124814562pri__cy
primary1437702primary
private121513262private
privily15207622privily
privity15268312privity
privy13439832priv__y
animacy1446103animacy
ariary94114203ari_ary
briary114912003bri_ary
friary124010093fri_ary
grimace1255083grimace
olivary1345163olivary
pacy115328683p___acy
papacy1547493p_apacy
pliancy1435593pliancy
pray96331533pr__a_y
preach133613923pr_each
preachy17307313pr_eachy
preact103220393pr_eact
preface14510923preface
prepack1757643prepack
prepay13310313prepa_y
prerace11414123prerace
prevail1238243prevail
priapi1037923pri_api
price93725413pri__ce
pricey134412633pri_cey
pricily142710283pricily
prick134317503pri__ck
prickly18367893prickly
pricky174210343pri_cky
prima95019343prima__
primage12169143primage
primal104014623prima_l
primas104418103prima_s
primate111516283primate
primely1457723primely
primly13439623pri_mly
prince104114763pri_nce
priorly12335763priorly
priory114110263pri_ory
prissy11347853pri_ssy
privacies1646803privacies
privately1744893privately
privater13158533privater
privates131812373privates
privet113821343priv_et
privets122910053privets
privier122910453privier
privies122414263privies
provably1846213provably
racy95825683_r__acy
rivage1038843_rivage
rival85216503_riva_l
rivalry1354033_rivalry
rivals94213183_rivals
triac74116373tri_ac_
triacs83913223tri_acs
trinary1039173trinary
tripack1565673tripack
urinary1037243urinary
vivace1436553_vivace
vivary1536983_vivary

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.406440125.6
2DLD Change Limit134027676.64020184.8
3Display Results67670.0135153.8
 (SQL Overall)178691677.05925313.9
 
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.