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

71 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
security134669(None) 
insecurity1552972insecurity
secularity1545772secularity
securely1345072securely
securing11310412securing
sedulity1245842sedulity
severity1446972severity
acuity1139373_acu_ity
becurst1147853becurst_
cecity1398153cec__ity
celerity1347643celerity
curite85222943__curite
decuries11312223decuries
decurion1146623decurion
decury1277963decur__y
equity1838103_equ_ity
eucrite939903_eucrite
fecundity1842523fecundity
ferity122813343fe__rity
futurity1454883futurity
impurity1544763impurity
jejunity1742453jejunity
jequirity2842713jequirity
legerity1245713legerity
maturity1367443maturity
obscurity1652803obscurity
purity114114913__purity
recruit939773recruit_
recruits1036563recruits
repurify1643803repurify
sacristy1345103sac_risty
salubrity1443163salubrity
scarcity1545093s_carcity
scarify1537443s_carify
scarily12311703s_carily
scorify1535203s_corify
scurfy14338763s_cur_fy
scurry11419593s_cur_ry
scurvily1643783s_curvily
scurvy14386103s_cur_vy
secrecy1444743sec_recy
secret8325063sec_ret_
secrete9311073sec_rete
secretly1345183sec_retly
secrets9311773sec_rets
sectility1447373sectility
secundly1443123secundly
secure8513533secur__e
secured1059723secur_ed
securer958253secur_er
securers1057153securers
secures9613163secur_es
securest1058583securest
securities1248553securities
securitize2153633securitize
senility1139683senility
seniority1246393seniority
senorita848283senorita
sequacity2343823sequacity
serenity1168963serenity
serosity1148783serosity
sexuality1946073sexuality
sincerity1445143sincerity
sonority1148533sonority
sorority1146903sorority
specularity1853963specularity
surety93515013s__urety
temerity1346903temerity
tenuity1037453tenu_ity
vacuity1545763vacu_ity
verity123714853ve__rity

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 Filter1786911461620.406440125.6
2DLD Change Limit146162717.11020557.2
3Display Results71710.0302366.7
 (SQL Overall)178691717.54623680.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.