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

101 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
primacy163560(None) 
primary1437701primary
privacy1744231privacy
animacy1446102animacy
grimace1255082grimace
piracy1339472p_iracy
prelacy1437582prelacy
pricy124814562pri__cy
prima95019342prima__
primage12169142primage
primal104014622prima_l
primas104418102prima_s
primate111516282primate
primely1457722primely
primly13439622prim_ly
ariary94114203ari_ary
briary114912003bri_ary
criminy14268453criminy
crimpy15489393crim_py
dramady1443563dramady
friary124010093fri_ary
gramary1355913gramary
grimaced1463313grimaced
grimacer1363963grimacer
grimaces1355383grimaces
grimily1336523grimily
grimly12459933grim_ly
grimy114312603grim__y
intimacy1544903intimacy
pacy115328683p___acy
palmary14338553palmary
papacy1547493p_apacy
pharmacy2043243pharmacy
pima85428653p_ima__
pimas94725103p_ima_s
pimply15329213p_imply
pliancy1435593pliancy
pomace123111913p_omace
pray96331533pr__a_y
preach133613923pr_each
preachy17307313pr_eachy
preact103220393pr_eact
preface14510923preface
premade12311443premade
preman104117453prema_n
prepack1757643prepack
prepay13310313prepa_y
prerace11414123prerace
priapi1037923pri_api
price93725413pri__ce
pricey134412633pri_cey
pricily142710283pricily
prick134317503pri__ck
prickly18367893prickly
pricky174210343pri_cky
prim85132203prim___
primacies1548453primacies
primages13159273primages
primality1687333primality
primarily1644673primarily
primatal1247133primatal
primates121515933primates
prime96525603prim__e
primed115118913prim_ed
primer105118683prim_er
primero11368923primero
primers114215673primers
primes104225263prim_es
primi95017403prim__i
primine113214823primine
priming123417373priming
primmed14388853primmed
primmer134310163primmer
primo95017913prim__o
primos104514423prim_os
primp115615923prim__p
primped14479153primped
primps124711823prim_ps
prims95425933prim__s
primsie1137543primsie
primula1145713primula
primus103712173prim_us
prince104114763pri_nce
priorly12335763priorly
priory114110263pri_ory
prissy11347853pri_ssy
private121513263private
privily15207623privily
privity15268313privity
privy13439833pri__vy
pyromancy2143593pyromancy
racy95825683_r__acy
rimy96621283_rim__y
supremacy1843053supremacy
triac74116373tri_ac_
triacs83913223tri_acs
trimly114410893trim_ly
trinary1039173trinary
tripack1565673tripack
ultimacy1543663ultimacy
urinary1037243urinary

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.483369960.7
2DLD Change Limit1340271016.75019855.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.27924548.8
 
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.