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

199 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
trinity1031084(None) 
triunity1145071triunity
aminity12310512aminity
aridity11510112aridity
crinite9513632crinite
privity15268312privity
tinily94014432t_inily
trilith10310512trilith
trinary1039172trinary
trining82919212trining
ability12311443ability
acidity1338593acidity
acridity1446913acridity
affinity1744983affinity
agility1148653agility
amenity1238333amenity
anility10312723anility
arenite71017713arenite
atrocity1347213atrocity
avidity1436483avidity
binit76431583_binit_
binits85716673_binits
bovinity1645023bovinity
brainily1337313brainily
brevity1534783brevity
brinier93613473brinier
brinies93317913brinies
brining103216473brining
brinish1239963brinish
briny104719663brin__y
caninity1338063caninity
criminy14268453criminy
crinites10612763crinites
crinkly16387523crinkly
crudity1336043crudity
dainty105311473dain_ty
dignity1236453dignity
dimity12310473_dimity
divinity1546163divinity
drifty13418223dri_fty
equinity2045653equinity
eternity1146683eternity
felinity1447283felinity
feminity1647543feminity
finite9316823_finite
finito9310303_finito
fixity19427803_fixity
flinty126112493flin_ty
fringy13309263frin_gy
fruity12429693fr_uity
glinty106910693glin_ty
granita82111303granita
granite82017083granite
gravity1437183gravity
grimily1336523grimily
gritty10338403gri_tty
inanity1039503inanity
infinity1447313infinity
kainit10414483kainit_
kainite1149543kainite
kainits1137763kainits
latinity1138813latinity
lenity9612713_lenity
linty87126563_lin_ty
minify1439253_minify
minty106323903_min_ty
moronity1347333moronity
ninety9510963_ninety
orality101111683orality
painty114714753pain_ty
pinite8321243_pinite
pointy114913283poin_ty
pricily142710283pricily
print74837463prin_t_
prints84320103prin_ts
priority1347443priority
privily15207623privily
probity14299683probity
putridity1544193putridity
rainily10310433rainily
rarity93615493_rarity
righty135011833_righty
rindy95717393_rin_dy
runty86119043_run_ty
salinity1138893salinity
sanity9316203_sanity
serenity1168963serenity
shinily13268933shinily
sterility1247763sterility
stringily1346003stringily
stringy114111073strin_gy
taint55542283tain_t_
taints64520533tain_ts
tawnily1335443tawnily
tensity1039103tensity
tenty86121603t_en_ty
tenuity1037453tenuity
tepidity1445603tepidity
thinly1238673thin_ly
thirsty1354083thirsty
thirty12378403thi_rty
thrifty1634193thri_fty
tidily102811393t_idily
timidity1445413timidity
tinct76126233t_inct_
tincts84510803t_incts
tingly103815973t_ingly
tinier63622233t_inier
tining74927543t_ining
tinkly134811153t_inkly
tinnily1047363tinnily
tinny85317653t_in_ny
tint46758863t_in_t_
tints56030923t_in_ts
tiny76134633t_in__y
titty85316653t_i_tty
tonicity1348543tonicity
torosity1147243torosity
torpidity1543833torpidity
torridity1344243torridity
toxicity2045683toxicity
training93015863training
trainway1444223trainway
trait56940843tr_ait_
traits65121983tr_aits
tranny94210863tran_ny
transit7317163transit_
transits8313503transits
treaty94414353tr_eaty
trendily1256443trendily
trendy10469603tren_dy
tribute937313tribute
trichite1349333trichite
tricing103417353tricing
trickily1736233trickily
trickly16369893trickly
tricksy16436583tricksy
tricky154211473tri_cky
tricot8317753tricot_
tricots9311563tricots
trifid1039063trifi_d
trigly103810943tri_gly
trijet133916553trijet_
trijets14308263trijets
trilby1144973tri_lby
triliths1145953triliths
trilogy1136013trilogy
trimly114410893tri_mly
trinal6516963trin_al
trindle83311363trindle
trine54734603trin__e
trined74920713trin_ed
trines64132563trin_es
trinities9313343trinities
trinket11314813trinket
trinketry1642803trinketry
trinkets1237143trinkets
triplite1039103triplite
triply114211023tri_ply
tripody13395983tripody
trippy13457803tri_ppy
trisomy1235943trisomy
triste63818643tri_ste
trite54730033tr__ite
tritely1039003tritely
tritium969013tritium
trivet93721883trivet_
trivets103911583trivets
trivia938503trivi_a
trivial1038713trivial
trivium1256143trivium
troilite849543troilite
trouty95211793tr_outy
trusty94710113tr_usty
tryingly1535883tryingly
tumidity1444953tumidity
turbidity15144293turbidity
turgidity14153313turgidity
twenty1236223twen_ty
twilit949553twilit_
twinier1037313twinier
twining113211443twining
twinkly1733913twinkly
twiny116012813twin__y
twisty12426863twi_sty
unity84918493__unity
uranite72515693uranite
urbanity13105303urbanity
urinary1037243urinary
urinate7315363urinate
utility1038703utility
vanity12311933_vanity
vicinity1645813vicinity
vinify1536923_vinify
virginity1642813virginity
viridity1545903viridity
virility1447733virility
wrinkly17295753wrinkly
wristy12509703wri_sty

Search took 10 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.313570897.8
2DLD Change Limit1340271999.37314299.3
3Display Results1991990.1431391.6
 (SQL Overall)1786911999.82918180.0
 
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.