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

115 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
tenancy123750(None) 
cotenancy1644662cotenancy
nancy105214922__nancy
penance11313442penance
regnancy1444772regnancy
tenably122210452tenably
tenace82715692tena_ce
tenant6322472tenan_t
tenantry1144262tenantry
tenants7311012tenants
tendance1147522tendance
tendency1445492tendency
tetany959842tetan_y
truancy1244992truancy
abeyancy1853053abeyancy
benny105217363ben_n_y
chancy164010863_chancy
decency1537453decency
denary105316863dena_ry
deviancy1754183deviancy
elegancy1444383elegancy
enact73525363_ena_ct
enhance1239693_enhance
errancy1256363errancy
fancy134615483__fancy
fenny115115133fen_n_y
finance1238573finance
geomancy1644153geomancy
infancy1546173infancy
iterance1049523iterance
jenny153811623jen_n_y
leanly93811503le_anly
legacy1256653lega_cy
leniency1345313leniency
lunacy1136843luna_cy
meanly115412043me_anly
meany104620483me_an_y
menace103216943mena_ce
nance74721843__nance
nanny84813813__nanny
peccancy1643953peccancy
penally121111773penally
penalty1267743penalty
penanced1338163penanced
penances12312443penances
penang92511113penan_g
penangs10268373penangs
pendency1646073pendency
penny105119453pen_n_y
pliancy1435593pliancy
pregnancy1744063pregnancy
recency1438633recency
regency1337363regency
seance83716693se_ance
senary93716073sena_ry
sonance9310313sonance
stagnancy1552553stagnancy
subtenancy1753063subtenancy
tangency1444563tangency
tangy94519933t__angy
tannoy958353tan_noy
tansy84514933t__ansy
teach105221123te_a_ch
teapoy1138113te_apoy
teary85124053te_a_ry
teensy9478273te_ensy
teeny85417883te_en_y
tenable93214493tenable
tenaces92814513tenaces
tenacity1347113tenacity
tenail64516113tena_il
tenails73713923tenails
tenancies1149173tenancies
tenanted937043tenanted
tench105620003te__nch
tendances1247573tendances
tendence1148523tendence
tenner64117103ten_ner
tennis64015303ten_nis
tenon53320513tenon__
tenoned839363tenoned
tenoner739683tenoner
tenons62916603tenon_s
tenpence1246403tenpence
tenpenny1342343tenpenny
tenrec837513tenrec_
tenrecs936033tenrecs
tensely1037363tensely
tensity1039103tensity
tenthly1335743tenthly
tenty86121603te__nty
tenuity1037453tenuity
ternary1038343terna_ry
testacy1235963testacy
tetanal738023tetanal
tetanic9810133tetanic
tetanics10127373tetanics
tetanus737933tetanus
tinny85317653tin_n_y
tonally10311373tonally
trance84718763t_rance
tranny94210863t_ranny
trenchancy2061903trenchancy
tunably12218293tunably
tunny86515033tun_n_y
twangy13386983t_wangy
twanky16445773t_wanky
tyranny1343063tyranny
unfancy1545203unfancy
vacancy1744443vacancy
venally13119563venally
verdancy1744723verdancy
wenny114412463wen_n_y
zenana15297983zenan_a
zenanas16286233zenanas

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.440406115.9
2DLD Change Limit1340271157.46617951.6
3Display Results1151150.0502300.0
 (SQL Overall)1786911157.95622459.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.