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

162 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
trinary103917(None) 
urinary1037241urinary
ariary94114202ari_ary
binary11312222_binary
briary114912002bri_ary
friary124010092fri_ary
granary1157792granary
ordinary1244912ordinary
primary1437702primary
quinary1936932quinary
ternary1038342ternary
tribunary1452242tribunary
trinal6516962trina_l
trinity10310842trinity
tripart9311432tripart
acinar8310483acinar_
apiary113910383api_ary
aviary12338413avi_ary
briar75718153bri_ar_
briard94311293bri_ard
briars84814823bri_ars
bribery14426493bribery
briery114510773bri_ery
briner84519043briner_
briners94315633briners
briny104719663brin__y
canary11314693_canary
coronary1347693coronary
crinkly16387523crinkly
culinary1355853culinary
denary105316863_denary
diary95016973_di_ary
dinar66319893_dinar_
dinars75417563_dinars
dreary104611673dr_eary
finery124512893_finery
friar85414273fri_ar_
friarly13316213fri_arly
friars93812093fri_ars
fringy13309263frin_gy
gramary1355903gramary
grindery13255513grindery
hymnary1843033hymnary
inarm7314423__inarm
joinery17366593joinery
kinara10310373_kinara
laminary13337253laminary
laniary1068013laniary
luminary13336653luminary
marinara1046493marinara
nary76931223___nary
olivary1345163olivary
ornery938463or_nery
pinery115214293_pinery
plenary1237543plenary
primacy1635603primacy
printery13318433printery
priory114110263pri_ory
privacy1744233privacy
rindy95717393_rin_dy
ritard74812083_ritard
rivalry1354033_rivalry
rosary92810353_rosary
rotary92411303_rotary
seminary1398093seminary
senary93716073_senary
stannary1144613stannary
stringy114111073strin_gy
tannery10388663tannery
teary85124053t__eary
termitary1444193termitary
tertiary1145433tertiary
thenar92610003thenar_
thenars10248523thenars
thinly1238673thin_ly
tiara5315913t_i_ara
tindery11389363t_indery
tingly103815973t_ingly
tinily94014433t_inily
tinkly134811153t_inkly
tinny85317653t_in_ny
tinware1038603t_inware
tiny76134633t_in__y
topiary1245813topiary
tracery12399793tracery
trainer73316793trainer_
trainers83114643trainers
trainway1444223trainway
tranny94210863tran_ny
tray77632593tr__a_y
treaty94414353tr_eaty
trenail7410813trenail
trendy10469603tren_dy
triac74116373tri_a_c
triacs83913223tri_acs
triad65217723tri_a_d
triads74513533tri_ads
triage72812893tri_age
trial54926353tri_a_l
trials64319883tri_als
triarchy1643613tri_archy
tribade1037293tribade
tribal8611133triba_l
tribally1347323tribally
tribals9610753tribals
tributary1462903tributary
trickery17297343trickery
trickly16369893trickly
tricksy16436583tricksy
tricky154211473tri_cky
tricorn937963tricorn
trier54328533tri_er_
triers64321523tri_ers
triform1237853triform
trigly103810943tri_gly
trigram1077763trigram
trilby1144973tri_lby
trilogy1136013trilogy
trimaran1045643trimaran
trimer85717153trimer_
trimers94615143trimers
trimly114410893tri_mly
trindle83311363trindle
trine54734603trin__e
trined74920713trin_ed
trines64132563trin_es
trining82919213trining
trinket11314813trinket
trinketry1642803trinketry
tripack1565673tripack
triply114211023tri_ply
tripody13395983tripody
trippy13457803tri_ppy
trisomy1235943trisomy
tritely1039003tritely
triter65120593triter_
triunity1145073triunity
trocar848773trocar_
trocars959043trocars
trona54118953trona__
tronas63816903trona_s
truancy1244993truancy
truantry1142543truantry
tryingly1535883tryingly
turbary1236383turbary
turnery10357423turnery
twiner94012593twiner_
twiners10459633twiners
twinkly1733913twinkly
twiny116012813twin__y
unary8315993__unary
unitary1038613unitary
urinal6614123urina_l
urinals7610253urinals
urinate7315363urinate
veterinary1652863veterinary
vinery124912603_vinery
vivary1536983_vivary
winery125014283_winery
wintry12498923_wintry
wrinkly17295753wrinkly
zonary1838793_zonary

Search took 7 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.390458182.1
2DLD Change Limit1340271626.06022116.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.51327436.1
 
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.