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

113 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
grammars1334594(None) 
grammar12406891grammar_
grammas12499771gramma_s
crammers14369342crammers
dammars12308192_dammars
gammas115714692g_amma_s
gammers123214562g_ammers
gramary1355902gra_mary
gramas94317202gra_ma_s
gramma11499802gramma__
grammes123611322gramm_es
grampas12399252grampa_s
rammers113715042_rammers
tramcars1245222tramcars
brahmas1436733brahma_s
brimmers14287073brimmers
clammers143510683clammers
crammer134010963crammer_
crimmers14298543crimmers
damars93814993_da_mars
dammar11438903_dammar_
dammers123214273_dammers
dramas95814653dra_ma_s
drawbars1483093drawbars
drummers13316163drummers
framers125113823fra_mers
gamas85431353g_a_ma_s
gamays126310903g_a_mays
gambas115817513g_amba_s
gambirs12359083g_ambirs
gamers94420823g_a_mers
gamma106116103g_amma__
gammer1112318333g_ammer_
gammons1237973g_ammons
gaydars1235803g_aydars
gazars164811553g_a_zars
gimmals12225823g_immals
glamors1068113gla_mors
glamours1184723glamours
glimmers13396153glimmers
graals74112913gra__als
grabbers13337883grabbers
graders94715993gra_ders
graduals1046203graduals
grafters12409183grafters
grahams1335333gra_hams
grainers93012073grainers
grama85620283gra_ma__
gramaries12128293gra_maries
gramarye1462713gra_marye
gramaryes1572873gra_maryes
grammarian1553403grammarian
grammarians1652443grammarians
gramme114210333gramm__e
grampa115010173grampa__
gramps114114273gra_m_ps
grampus12356313gra_mpus
grams85327313gra_m__s
granary1157793gra_nary
grandads1136553grandads
grandams1237123grandams
grandmas1236923grandma_s
grangers103011973grangers
granters93614133granters
grantors93810353grantors
grappas12357103grappa_s
graspers11338393graspers
graters85419733gra_ters
gravers114515263gra_vers
gravlaks1642423gravlaks
graylags1372983graylags
graymail1443273graymail
graymails1542783graymails
grazers175112443gra_zers
graziers18387123graziers
gremials1136133gremials
gremmies1355993gremmies
grimmer123510093grimmer_
grommets13234663grommets
groomers11388483groomers
grummer12338783grummer_
grummets13275033grummets
gummas114810513g_umma_s
gummers123712193g_ummers
hammals14409213_hammals
hammams13386433_hammams
hammers144216053_hammers
jammers183710703_jammers
krimmers16315673krimmers
mammals10389273_mammals
mammary1335993_mammary
mammas94616403_mamma_s
mammers104615693_mammers
radars71314663_ra_dars
rammer103519653_rammer_
rampart11311993_rampart
ramparts1245583_ramparts
rimmers113812883_rimmers
rummers113513653_rummers
sambars115113843_sambars
scammers14339773scammers
shammas14358713shamma_s
shammers153710833shammers
slammers123511223slammers
spammers14378693spammers
stammers123611523stammers
tramcar1135593tramcar_
trammels12295413trammels
trampers123210373trampers
tramways1643723tramways
traumas938583trauma_s
trimmers12288913trimmers
yammers143410323_yammers

Search took 9 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.1701051123.5
2DLD Change Limit1461621137.95318378.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.16921874.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.