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

99 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
secrecy144474(None) 
screwy14659452s_crewy
secret8325062secre_t
secrete9311072secrete
secretly1345172secretly
secrets9311772secrets
securely1345062securely
crepy124812703__crepy
decency1537453decency
decree93117783decre_e
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
decry115514353decr__y
erect74129333_e_rect
ferrety13287013ferrety
hereby14468333he_reby
heresy125011233he_resy
isocracy1543813isocracy
lechery15257643lechery
mercery14397623mercery
mercy125916183me_r_cy
merely111312583me_rely
recency1438633recency
recheck1835613recheck
recreancy1643783recreancy
reerect92915883reerect
sacred94917103sacre_d
sacredly1444463sacredly
scarey115016983scare_y
scenery1236553scenery
screak125311053s_creak
screaky16436213s_creaky
scream104814243s_cream
scree720031703s_cre_e
screech1435213s_creech
screechy1842763s_creechy
screed95718923s_creed
screen85216013s_creen
screes85023963s_crees
screw109318533s_cre_w
screws115513883s_crews
scry96017763s_cr__y
sealery104011053sealery
search113312423sear_ch
seared75232843seare_d
searer65432023seare_r
searest73322023searest
secco9312423sec__co
secede93311993sec_ede
secern81010223sec_ern
secerns987733secerns
secrecies1346913secrecies
secretary1444193secretary
secreted1138633secreted
secreter1038503secreter
secretes10410473secretes
secretin10108343secretin
secretor1045673secretor
secretory1444593secretory
sectary1238273sectary
secure8513533secure__
secured1059723secure_d
securer958253secure_r
securers1057153securers
secures9613163secure_s
securest1058583securest
security1346693security
seedy94821533se__edy
seely84522633se__ely
seepy104717973se__epy
seeress7311573seeress
select82621173se_lect
seneca839793se_neca
sequency2244493sequency
serac75925203se_rac_
seracs84418573se_racs
sere46153473se_re__
sered65737293se_re_d
serein63318463se_rein
serene63522353se_rene
serer55935503se_re_r
seres55448893se_re_s
serest64831613se_rest
serry84824123se_r_ry
severely1445283severely
society1236083society
sorcery1237023sorcery
sorely94618003s_orely
sparely123410663sparely
sprucy13356323s_prucy
storey95217613store_y
sucre75019103sucre__
sucres84218893sucre_s
surely93816453s_urely
surety93515003s_urety
surrey94414573surre_y
tenrec837513tenrec_
tenrecs936033tenrecs

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.1731032896.0
2DLD Change Limit134027997.62317581.9
3Display Results99990.0333000.0
 (SQL Overall)178691997.82922824.2
 
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.