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

87 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
granular94690(None) 
ranular739441_ranular
canular9310332_canular
frenular1144632frenular
glandular1142792glandular
granola837912granola_
granolas938062granolas
granulate1059182granulate
granulator1155102granulator
granule839472granul_e
granules939942granules
oracular1047542oracular
planular1044762planular
radular837842_radular
ranula6311812_ranula_
ranulas7311782_ranulas
alular6311363__alular
angular838543__angular
annular737703_annular
cannular1046293cannular
canula8312973_canula_
canulae9311193_canulae
canulas9312863_canulas
fabular12288703_fabular
facular122810453_facular
frenula1045623frenula_
gangliar1064123g_angliar
globular1143383globular
grabbler13377693grabbler
gradual936943gradu_al
graduals1046203graduals
grammar12406893gra_mmar
grana65722093gran__a_
granary1157793gran__ary
grandad1038453gran_dad
grandam1139393gran_dam
granddad1244253granddad
granddam1344693granddam
grander93315873gran_der
grandeur10305673grandeur
grandly1238743grandl_y
grandma1136913grandma_
grandmas1236923grandmas
grandpa1135413grandpa_
grandpas1236003grandpas
grandsir1044313grandsir
granger93514213gran_ger
granita82111303granita_
granitas92610223granitas
granter84117133gran_ter
grantor84010943gran_tor
granularity1553313granularity
granulated1256943granulated
granulates1148463granulates
granulators1244613granulators
granulite1046923granulite
granuloma1252393granuloma
granulomas1352123granulomas
granulose1044143granulose
granum9310913granu__m
grappler13336193grappler
gratulate1047683gratulate
gravlax1842643gra_vlax
graylag1283113gra_ylag
grossular1042773grossular
gular6314833g___ular
hamular1236983_hamular
lunular736023_lunular
macular113011953_macular
nongranular12101583nongranular
pabular11259483_pabular
papular11299773_papular
piacular1246583piacular
pinnular1044433pinnular
planula935773planula_
planulae1044793planulae
radula749313_radula_
radulae837963_radulae
radulas839583_radulas
regular838423_regular
scapular1245383scapular
spatular1044663spatular
tabular9279773_tabular
triangular1162873triangular
venular1037683_venular
wrangler1245473wrangler
zonular1656493_zonular

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 Limit146162877.50019488.3
3Display Results87870.0302900.0
 (SQL Overall)178691877.95322468.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.