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

139 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
tridents93858(None) 
trident8314191trident_
orients7311582ori_ents
rident7520192_rident_
rodents8611542_rodents
strident9310172strident_
tridental1046622tridental
trienes74118412tri_enes
triens65417542tri_en_s
trientes82812122tri_entes
trijets14308262trije_ts
trisects1035982trisects
trivets103911582trive_ts
accidents14155133accidents
aliments10311093aliments
ardent73022613ar_dent_
argents84014853ar_gents
aridest8316143aridest_
aridness939223aridness
arpents93613083ar_pents
audients946353audients
bidets95215533_bide_ts
brents84717273br__ents
brides94423513bride__s
clients938093cli_ents
credent10313973credent_
dents65031803___dents
detriments1347363detriments
erodent8313823erodent_
evident1139993evident_
friends11396743fri_ends
gradients1145273gradients
grides84422363gride__s
grivets11357973grive_ts
hoidens11329083hoiden_s
incidents1246803incidents
indents83114663_indents
irides74519123iride__s
irridenta1063923irridenta
irridentas1163443irridentas
maidens10349663maiden_s
mordents1138813mordents
nutrients944423nutri_ents
nutriments1244803nutriments
occidents14103833occidents
orient6322533ori_ent_
orpiments1346003orpiments
oxidants1643933oxidants
pendents1139413pendents
precents123015043precents
presents103315643presents
presidents1347023presidents
prevents133012293prevents
prides94324183pride__s
priests93810863pri_ests
prints84320103pri__nts
privets122910053prive_ts
prudent10310433prudent_
raiments1039903raiments
regents83416543_regents
relents74018503_relents
rents55935183_r__ents
repents93717623_repents
rerents73319423_rerents
resents74221223_resents
residents1038423residents
riders74123903_ride_rs
rides66140813_ride__s
ridings93412093_ridings
ripens85012173_ripen_s
rivets94417113_rive_ts
rodent7519243_rodent_
silents73514493_silents
stridence1245103stridence
stridences1344733stridences
stridency1543903stridency
stridently1454593stridently
striders94412123stride_rs
strides84520393stride__s
students954683students
taints64520533tai__nts
talents7312013t_alents
tangents938713tangents
tents56434213t___ents
tidbits1035183t_idbits
tides64830153t_ide__s
tidings93810263t_idings
tints56030923t_i__nts
toilets74112913toile_ts
torments10310453torments
torrents838143torrents
traders84316953trade_rs
trades75724503trade__s
trajects1744533trajects
treats64821693tr__eats
trecento1066213trecento
trecentos1155873trecentos
treens65317873tr_een_s
trends75513543tr__ends
trets55928023tr__e_ts
trevets10499973treve_ts
tribes85119023tribe__s
tribunes1055853tribunes
triceps11267343trice_ps
trices84826333trice__s
tricots9311563tri_cots
triduums1142613triduums
triene64316383tri_en_e
triers64321523tri_e_rs
tries55742813tri_e__s
trifecta1343573trifecta
trifectas1443653trifectas
trigness968403trigness
trigons84312093trigon_s
trijet133916553trije_t_
trikes105419493trike__s
trimers94615143trime_rs
trimness1067563trimness
trines64132563tri__nes
trinkets1237143trinkets
triodes84012503triode__s
triolets83410143triolets
tripes85324873tripe__s
triplets103510263triplets
trippets12357423trippets
triremes1035523triremes
trisect939733trisect_
trisemes1036643trisemes
triteness9310363triteness
tritest7315273tritest_
tritones83413443tritones
tritons73814883triton_s
triunes74311383tri_unes
trivet93721883trive_t_
truants738163tr_uants
trudgens10255153trudgen_s
uridines989513uridines
widens106212723_widen_s
wisents10249063_wisents

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.1731032896.0
2DLD Change Limit1461621397.42319690.4
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.65923330.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.