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

127 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
grimmest1328629(None) 
grimiest11299821grimiest
grummest13286361grummest
primmest14226691primmest
trimmest12227021trimmest
dimmest1249252_dimmest
gimmes113010902g_immes_
glummest13235562glummest
grammes123611322grammes_
grimes94619032gri_mes_
grimmer123510092grimme_r
grimness1175992grimness
gripiest11289632gripiest
grommet12268452gromme_t
grommets13234662grommets
grummet12298872grumme_t
grummets13275032grummets
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
gamest94919933g__amest
gamiest102816233g_amiest
gammiest13339333gammiest
gemmiest13227633gemmiest
germiest11249923germiest
gimlet93716663g_imle_t
gimlets10338433g_imlets
gimme102411343g_imme__
gimmies123010113g_immies_
gimpiest1338483g_impiest
girliest93010403girliest
glibbest1343683glibbest
glimes94717523gli_mes_
glimmer12437713glimme_r
glimmers13396153glimmers
goriest82218743gori__est
grainiest10188993grainiest
grammas12499773grammas_
gramme114210333gramme__
grandest10311573grandest
grapiest112211923grapiest
gravest114011633gr_avest
grayest11489363gr_ayest
greatest939863greatest
greenest9312623greenest
gremmies1355993gremmies_
greyest11348343gr_eyest
grides84422363gri_des_
grieves1137323grieves_
griffes14367923griffes_
grilles83715023grilles_
grilses8319153grilses_
grimaces1355383grimaces_
grime85021323gri_me__
grimed104714093gri_me_d
grimier103210433grimie_r
griminess1236703griminess
gripes94619873gri_pes_
gripmen1235033gripme_n
grippes124810373grippes_
grippiest1435143grippiest
grisliest1047353grisliest
grist65529873gri___st
grittiest10176983grittiest
grivet103517823gri_ve_t
grivets11357973gri_vets
grodiest10310553grodiest
grossest93810093grossest
gruffest1544593gruffest
grumes94415553gr_umes_
grummer12338783grumme_r
grumpiest1435023grumpiest
guimpes1245073guimpes_
gummiest13269033gummiest
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
swimmiest1634253swimmiest
triggest1036923triggest
trimmed12348933trimme_d
trimmer113610833trimme_r
trimmers12288913trimmers
trimness1067563trimness
tritest7315273tri_test
tsimmes1133673tsimmes_
tzimmes2033063tzimmes_
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.420425454.8
2DLD Change Limit1461621276.79621507.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.26224606.3
 
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.