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

221 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
trident831419(None) 
rident7520191_rident
strident9310171strident
tridents938581tridents
ardent73022612ar_dent
aridest8316142aridest
credent10313972credent
erodent8313822erodent
evident1139992evident
orient6322532ori_ent
prudent10310432prudent
rodent7519242_rodent
tridental1046622tridental
triene64316382tri_ene
triens65417542tri_ens
trijet133916552trije_t
trisect939732trisect
tritest7315272tritest
trivet93721882trive_t
accident13148183accident
acridest1138143acridest
aliment9316703aliment
argent74023663ar_gent
arider74717743aride_r
arisen65316793arisen_
arpent84822093ar_pent
audient8312303audient
bidet84935623_bide_t
brent75734133br__ent
bride86425533bride__
brides94423513bride_s
brisant9312683brisant
cadent94120363_cadent
candent10417363candent
client8316343cli_ent
crudest104510333crudest
dent57158413___dent
detriment1249693detriment
diriment11410743diriment
driest74722753dri_est
driven105210143driven_
eminent9313853eminent
exigent1539513exigent
friend10388933fri_end
gradient10310373gradient
gride75223583gride__
grided95117043gride_d
grides84422363gride_s
griding103014973griding
grivet103517823grive_t
hoiden103612333hoiden_
hoidens11329083hoidens
incident11410203incident
indent73021243_indent
irides74519123iride_s
irridenta1063923irridenta
maiden93512283maiden_
maidens10349663maidens
mordent10313993mordent
nutrient848353nutri_ent
nutriment1146503nutriment
occident13126293occident
orients7311583ori_ents
orpiment1247973orpiment
oxidant1547363oxidant
pendent10314723pendent
precent113520263precent
present94022733present
president12410993president
prevent124016553prevent
pride84724733pride__
prided103618033pride_d
prides94324183pride_s
priding113317543priding
priest84125423pri_est
print74837463pri__nt
privet113821343prive_t
provident1546223provident
raiment9315413raiment
recent83630853_recent
redeny102712733_redeny
regent74127673_regent
relent64431853_relent
rent46661243_r__ent
repent84728873_repent
rerent63832453_rerent
resent63833623_resent
resident9313753resident
riant55833153_ri_ant
ridden83511723_ridden_
ride55945133_ride__
rider65231303_ride_r
riders74123903_riders
rides66140813_ride_s
riding84325963_riding
rifest93114583_rifest
ringent8315153_ringent
ripen75619263_ripen_
ripens85012173_ripens
ripest84317943_ripest
risen54621883_risen_
riven85121623_riven_
rivet85636363_rive_t
rodents8611543_rodents
rudest74016313_rudest
silent64125843_silent
snidest8310913snidest
staidest939803staidest
stridden1044273stridden_
stride75420963stride__
stridence1245103stridence
stridency1543903stridency
stridently1454593stridently
strider84315723stride_r
striders94412123striders
strides84520393stride_s
striding102713603striding
stringent1049093stringent
striven103910753striven_
student848343student
taint55542283tai__nt
talent6323323t_alent
tangent8314993tangent
tardiest93515243tardiest
tent46159863t___ent
thriven13447023thriven_
tidbit938493t_idbit
tide55237383t_ide__
tided76322513t_ide_d
tides64830153t_ide_s
tidiest83514873t_idiest
tiding83520093t_iding
timidest1136933timidest
tint46758863t_i__nt
tiredest938403tiredest
toilet66228093toile_t
torment9316173torment
torrent7313413torrent
torridest1045753torridest
trade65026043trade__
traded85717683trade_d
trader75218763trade_r
traders84316953traders
trades75724503trade_s
trading93517973trading
traject1637043traject
treat56240353tr__eat
trecento1066213trecento
treen55622753tr_een_
treens65317873tr_eens
trend64817453tr__end
trepidant1244663trepidant
tret46653533tr__e_t
trevet94818913treve_t
tribe74420273tribe__
tribes85119023tribe_s
tribune945573tribune
trice75127493trice__
triced95518673trice_d
tricep103911073trice_p
triceps11267343triceps
trices84826333trice_s
tricing103417353tricing
tricot8317753tri_cot
triduum1043413triduum
tried65026913tri_e_d
trienes74118413tri_enes
trientes82812123tri_entes
trier54328533tri_e_r
triers64321523tri_ers
tries55742813tri_e_s
trifecta1343573trifecta
triggest1036923triggest
trigon74513103trigon_
trigons84312093trigons
trijets14308263trijets
trike95320163trike__
trikes105419493trike_s
trimer85717153trime_r
trimers94615143trimers
trimmest12227023trimmest
trine54734603tri__ne
trined74920713trine_d
trines64132563trine_s
trining82919213trining
trinket11314813trinket
triode75311893triode__
triodes84012503triode_s
triolet73219523triolet
tripart9311433tripart
tripe75425383tripe__
tripes85324873tripe_s
triplet94319213triplet
trippet113714113trippet
trireme935263trireme
trisects1035983trisects
triseme936543triseme
trite54730033trite__
tritely1039003tritely
triter65120593trite_r
triton63914893triton_
tritone73613883tritone
tritons73814883tritons
triune64210183tri_une
triunes74311383triunes
trivalent1246483trivalent
trivets103911583trivets
trodden934883trodden_
trode65322853trode__
truant6315783tr_uant
trudgen9357053trudgen_
trudgens10255153trudgens
truest64816193tr_uest
turgent8712393turgent
urgent73816043ur_gent
uridine81311213uridine
widen94717973_widen_
widens106212723_widens
widest104517003_widest
wisent93516343_wisent
wriest94419713wri_est

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.420425454.8
2DLD Change Limit1340272217.11018850.5
3Display Results2212210.0932376.3
 (SQL Overall)1786912217.62323441.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.