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 “grimaced” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
grimaced146331(None) 
grimace1255081grimace_
grimacer1363961grimacer
grimaces1355381grimaces
graced105217902gr__aced
grimacers1463552grimacers
grimed104714092grim__ed
animated111612373animated
braced115420603br__aced
brigaded1344573brigaded
brimmed14386783brim_med
bromated1339173bromated
climaxed2043113climaxed
cremated133412963cremated
crimped143910763crim_ped
crimpled15366933crimpled
gemmated14336293gemmated
gimbaled14104173g_imbaled
gimped123911473g_im_ped
glimed105312283glim__ed
glimpsed1442773glimpsed
grace85124543gr__ace_
graces94523493gr__aces
gradated1157433gradated
graded94919553gr__aded
grated84523923gr__ated
graved114818813gr__aved
grayed115415643gr__ayed
grazed174115913gr__azed
greased93812393gr_eased
greaved12408913gr_eaved
gridded11387583gri_dded
griddled1244203griddled
grided95117043gri__ded
grieved1235283gri_eved
grifted12379583gri_fted
grilled94012833gri_lled
grimacing1544033grimacing
grime85021323grim__e_
grimes94619033grim__es
grimier103210433grim_ier
grimmer123510093grim_mer
grinded104210633gri_nded
grinned9378553gri_nned
griped104114713gri__ped
gripped13419343gri_pped
gritted94110903gri_tted
grizzled18334893grizzled
groaned9259973gr_oaned
grumbled14256753grumbled
grumped13337333grum_ped
imaged1097763__imaged
maced108528693___maced
prefaced1638423prefaced
priced115018883pri__ced
primacies1548453primacies
primacy1635603primac_y
primage12169143primage_
primages13159273primages
primate111516283primate_
primates121515933primates
primed115118913prim__ed
primmed14388853prim_med
primped14479153prim_ped
raced87635313_r__aced
refaced133713573_refaced
reimaged1246173reimaged
relaced103517213_relaced
remated103522473_remated
riced85825543_ri__ced
rimed84826373_rim__ed
rimmed114812303_rim_med
rimpled123311423_rimpled
rivaled1138933_rivaled
romanced1337253_romanced
traced94821583tr__aced
triacid1038593tri_acid
triaged92810443tri_aged
triced95518673tri__ced
trimmed12348933trim_med
urinated9311613urinated

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.453394461.4
2DLD Change Limit146162816.36022981.4
3Display Results81810.0332454.5
 (SQL Overall)178691816.84626101.5
 
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.