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

149 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
grammar1240689(None) 
gramma11499801gramma_
grammars13345941grammars
grammas12499771grammas
crammer134010962crammer
dammar11438902_dammar
gamma106116102g_amma_
gammas115714692g_ammas
gammer1112318332g_ammer
grama85620282gra_ma_
gramary1355912gra_mary
gramas94317202gra_mas
gramme114210332gramm_e
grammes123611322grammes
grampa115010172grampa_
grampas12399252grampas
grimmer123510092grimmer
grummer12338782grummer
rammer103519652_rammer
tramcar1135592tramcar
brahma1336193brahma_
brahmas1436733brahmas
brimmer13348803brimmer
clammer134211793clammer
crammed143710123crammed
crammers14369353crammers
crimmer133310773crimmer
damar84117743_da_mar
dammars12308193_dammars
dammer114317933_dammer
drama85117423dra_ma_
dramas95814663dra_mas
drammed13378073drammed
drawbar13103193drawbar
drayman1335433drayman
drummer12407503drummer
framer114817443fra_mer
gagman103811243g_agman
gama77035523g_a_ma_
gamas85431363g_a_mas
gamay116419113g_a_may
gamba106018513g_amba_
gambas115817513g_ambas
gambir11509773g_ambir
gamer84928943g_a_mer
gamier93617933g_amier
gammed124216163g_ammed
gammers123214563g_ammers
gammier123711193g_ammier
gammon1138903g_ammon
gammy135514893g_amm_y
gasman92911743g_asman
gaydar1135503g_aydar
gazar154612983g_a_zar
gemma106311773g_emma_
gemmae11507793g_emmae
gimmal11247513g_immal
glamor958193gla_mor
glamour1065143glamour
glimmer12437713glimmer
glummer12417983glummer
graal64316503gra__al
grabber12389763grabber
grader84919693gra_der
gradual936943gradual
grafter114211153grafter
graham1237853gra_ham
grahams1335333grahams
grainer83714063grainer
gram77034583gra_m__
gramarye1462723gra_marye
grammarian1553423grammarian
gramp106218323gra_m_p
gramps114114273gra_mps
grampus12356313grampus
grams85327313gra_m_s
grana65722093gra_na_
granary1157793gra_nary
grandad1038453grandad
grandam1139393grandam
grander93315873grander
grandma1136913grandma_
grandmas1236923grandmas
granger93514213granger
granter84117133granter
grantor84010943grantor
granular946893granular
grapier103712603grapier
grappa11396443grappa_
grappas12357103grappas
grasper10389793grasper
grater74625443gra_ter
graver105018593gra_ver
gravlax1842643gravlax
grayer106014543gra_yer
graylag1283113graylag
graymail1443273graymail
grazer164815763gra_zer
grazier173611133grazier
gremial1039153gremial
gremmie1264383gremmie
gremmy1454473gremm_y
grimier103210433grimier
gripman1234463gripman
grommet12268453grommet
groomer10399873groomer
grummet12298873grummet
gumma105313103g_umma_
gummas114810513g_ummas
gummer114615453g_ummer
hammal134512063_hammal
hammam12419333_hammam
hammer138120033_hammer
jammer174014133_jammer
krimmer15376873krimmer
mamma86317913_mamma_
mammae94613213_mammae
mammal95112753_mammal
mammary1335993_mammary
mammas94616403_mammas
mammer94218863_mammer
palmar104113463_palmar
primmer134310163primmer
radar61316723_ra_dar
ragman94013713_ragman
ramal74622243_ra_mal
rammed113117303_rammed
rammers113715043_rammers
rammier112811023_rammier
rammy124312493_ramm_y
rampart11311993_rampart
rimmer103516033_rimmer
rummer104715483_rummer
sambar103914163_sambar
scammer133611973scammer
shammas14358723shammas
shammer144613143shammer
slammer113913033slammer
spammer133410433spammer
stammer116013343stammer
tramcars1245233tramcars
trammed123810713trammed
trammel11357663trammel
tramper113812163tramper
tramway1544863tramway
trauma838803trauma_
traumas938593traumas
trimmer113610833trimmer
yammer133713183_yammer

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271496.20321606.8
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.65526850.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.