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

131 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
primmest1422669(None) 
grimmest13286291grimmest
trimmest12227021trimmest
dimmest1249252_dimmest
grimiest11299822grimiest
grummest13286362grummest
plummest14276412plummest
priciest122112902priciest
priest84125422pri__est
primes104225262pri_mes_
primmed14388852primme_d
primmer134310162primme_r
primness1276762primness
priviest132310312priviest
rimiest93215852_rimiest
rummest11279832_rummest
slimmest1235902slimmest
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
palmiest123212023palmiest
pigment12510733p_igment
piniest93121133p_iniest
pinkest132812623p_inkest
pipiest113114493p_ipiest
plumiest122110293plumiest
plummet13278353plumme_t
plummets14304773plummets
plummiest1544973plummiest
plumpest14236353plumpest
premeet11615153pr_emeet
premies113823063premies_
prest75736353pr___est
pretest9517633pr_etest
prices104524543pri_ces_
pricket153616443pricke_t
prickets16329083prickets
prickiest1748183prickiest
prides94324183pri_des_
pries74339533pri__es_
priests93810863pri__ests
primages13159273primages_
primas104418103pri_mas_
primates121515933primates_
prime96525603pri_me__
primed115118913pri_me_d
primely1457723pri_mely
primeness1338653primeness
primer105118683pri_me_r
primero11368923pri_mero
primers114215673pri_mers
primines123013703primines_
primming15268173primming
primos104514423pri_mos_
primped14479153primpe_d
primps124711823pri_mps_
primrose1244503primrose
prims95425933pri_m_s_
primus103712173pri_mus_
primuses1237083primuses
princes113015143princes_
princess12266803princess
prioress1035393prioress
prises84133173pri_ses_
prisms104915503prism_s_
prisses94816713prisses_
prissiest11178903prissiest
privatest14196733privatest
privet113821343pri_ve_t
privets122910053pri_vets
privies122414263privies_
prizes173819813pri_zes_
promptest1546063promptest
prosiest10416523prosiest
protest9317533pr_otest
proudest1138943proudest
prowest12311533pr_owest
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
spriest92718643spri__est
swimmiest1634253swimmiest
triggest1036923triggest
trimmed12348933trimme_d
trimmer113610833trimme_r
trimmers12288913trimmers
trimness1067563trimness
tritest7315273tri_test
tsimmes1133673tsimmes_
tzimmes2033063tzimmes_
wriest94419713wri__est

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621316.40622816.4
3Display Results1311310.0602183.3
 (SQL Overall)1786911316.88925938.6
 
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.