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 “trimmest” 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
trimmest1222702(None) 
grimmest13286291grimmest
primmest14226691primmest
dimmest1249252_dimmest
grimiest11299822grimiest
grummest13286362grummest
rimiest93215852_rimiest
rummest11279832_rummest
slimmest1235902slimmest
triggest1036922triggest
trimmed12348932trimme_d
trimmer113610832trimme_r
trimmers12288912trimmers
trimness1067562trimness
tritest7315272tri_test
tsimmes1133672tsimmes_
tzimmes2033062tzimmes_
aridest8316143ari_dest
armrest9310163ar_mrest
briefest1335893briefest
brimless1235273brimless
brimmed14386783brimme_d
brimmer13348803brimme_r
brimmers14287073brimmers
briniest102812323briniest
briskest14337803briskest
bummest13298623_bummest
crimes105521583cri_mes_
crimmer133310773crimme_r
crimmers14298543crimmers
crimpiest15237183crimpiest
crispest12177373crispest
crummiest1545563crummiest
driest74722753dri__est
firmest1239273_firmest
gimmes113010903_gimmes_
glummest13235563glummest
grammes123611323grammes_
grimes94619033gri_mes_
grimmer123510093grimme_r
grimness1175993grimness
gripiest11289633gripiest
grommet12268453gromme_t
grommets13234663grommets
grummet12298873grumme_t
grummets13275033grummets
immesh1334113__immesh
jimpest18297553_jimpest
krimmer15376873krimme_r
krimmers16315673krimmers
limiest93716103_limiest
limpest113712313_limpest
plummest14276413plummest
priciest122112903priciest
priest84125423pri__est
primes104225263pri_mes_
primmed14388853primme_d
primmer134310163primme_r
primness1276763primness
priviest132310313priviest
rammiest12299933_rammiest
richest122813683_richest
rifest93114583_ri_fest
rimes75634543_ri_mes_
rimless9369363_rimless
rimmed114812303_rimme_d
rimmer103516033_rimme_r
rimmers113812883_rimmers
ripest84317943_ri_pest
rummiest12299353_rummiest
slimiest10310743slimiest
strictest1147293strictest
stripiest1138013stripiest
swimmiest1634253swimmiest
tamest85721293t__amest
tempest1139223t_empest
thickest17337303thickest
thinnest11248893thinnest
thrummiest1742093thrummiest
thymiest1634733thymiest
tidiest83514873t_idiest
times75630823t_i_mes_
timidest1136933t_imidest
tiniest73020123t_iniest
tiredest938403tiredest
tramless1037503tramless
trammed123810713tramme_d
trammel11357663tramme_l
trammels12295413trammels
trampiest13227893trampiest
trapnest10310923trapnest
triages82613793triages_
tribes85119023tri_bes_
trices84826333tri_ces_
trickiest1549023trickiest
trident8314193tri_dent
trienes74118413trienes_
tries55742813tri__es_
trifles103814823trifles_
trigness968403trigness
trijet133916553tri_je_t
trijets14308263tri_jets
trikes105419493tri_kes_
trimer85717153tri_me_r
trimers94615143tri_mers
trimester1145823tri_mester
trimming13318653trimming
trims75021473tri_m_s_
trines64132563tri_nes_
trinket11314813trinke_t
trinkets1237143trinkets
triodes84012503triodes_
triolet73219523triole_t
triolets83410143triolets
trioses75015653trioses_
tripes85324873tri_pes_
triples94616873triples_
triplet94319213triple_t
triplets103510263triplets
trippet113714113trippe_t
trippets12357423trippets
trippiest1336583trippiest
triremes1035523triremes_
trisect939733tri_sect
trisemes1036643trisemes_
trismus935563trismus_
trisomes1039833trisomes_
tritheist1247213tritheist
triunes74311383triunes_
trivet93721883tri_ve_t
trivets103911583tri_vets
trommel11315363tromme_l
trommels12254333trommels
trompes114111623trompes_
truest64816193tr__uest
trumpet113810723trumpe_t
trumpets12315573trumpets
twiniest1147153twiniest
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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.31319986.6
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.79922912.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.