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

151 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
grahams133533(None) 
graham1237851graham_
brahmas1436732brahmas
graals74112912gra_als
gramas94317202grama_s
grammas12499772grammas
grams85327312gr__ams
grandams1237122grandams
praams10459642pra_ams
arhats9312973ar_hats
brahma1336193brah_ma
bravas114913323brava_s
brazas175812433braza_s
breams104815043br_eams
brechams1745773brechams
chams126028503__chams
craals84113303cra_als
crams96229153cr__ams
cravats1237403cravats
creams104715253cr_eams
dirhams13376313dirhams
drachmas1644863drachmas
drachms1534253drachms
dramas95814663drama_s
drams86025833dr__ams
dreams94513983dr_eams
fracas11311993fraca_s
fulhams1543983fulhams
galahs105512683g_alahs
galas65731643g_ala_s
gamas85431363g_ama_s
gamays126310913g_amays
gammas115714693g_ammas
gams76648883g___ams
gaums86217073g_a_ums
gayals1039513g_ayals
gazars164811553g_azars
gerahs1039413gerah__s
ghats95818613g__hats
ginghams1573903ginghams
glams85822933g__lams
gleams94812253g_leams
gloams95210663g_loams
goddams1233983goddams
graal64316503gra_a_l
grabens10367003grabens
grabs85719693gr__abs
graces94523493gra_ces
gradate9511233gradate
gradates10510783gradates
graders94716013graders
grades84926313gra_des
gradins93416233gradins
grads75625753gr__ads
graduals1046203graduals
gradus84411223gra_dus
grafts105013253gra_fts
grails77518783gra_ils
grains74223093gra_ins
gram77034583gr__am_
grama85620283gr__ama
gramary1355913gramary
gramma11499803gra_mma
grammar12406893grammar
grammars13345943grammars
gramme114210333gra_mme
grammes123611323grammes
gramp106218323gr__amp
grampas12399253grampas
gramps114114273gra_mps
grampus12356313grampus
grana65722093grana__
granary1157793granary
grandads1136553grandads
grandam1139393grandam_
grandame1247113grandame
grandames1346713grandames
granddams1443483granddams
grandma1136913grandma
grandmas1236923grandmas
grands84218243gra_nds
granges93516523granges
grans64832543gr__ans
grants73722473gra_nts
granum9310913granum_
grapes95123123gra_pes
grapheme1644013grapheme
graphemes1743633graphemes
graphics1645653graphics
graphs124510153gra_phs
grappas12357103grappas
grasps9489253gra_sps
grass66125203gr__ass
grasses84117343grasses
graters85419743graters
grates75429893gra_tes
gratins84119183gratins
gratis74819243gra_tis
gravamen1443933gravamen
gravamens1542783gravamens
gravels113611143gravels
gravers114515273gravers
graves104624003gra_ves
gravies11314093gravies
gravlaks1642423gravlaks
graylags1372983graylags
grays95621333gr__ays
grazers175112453grazers
grazes164519643gra_zes
greats76318393gr_eats
groans74815063gr_oans
groats74816653gr_oats
grograms1246023grograms
grooms94512523gr_ooms
guaiacs1054353guaiacs
guanays1134953guanays
guavas1037163guava_s
hahas117118443_haha_s
hams96446133___hams
kalams12310603_kalams
kraals10378433kra_als
lahars94013163_lahars
madams11310943_madams
marrams11310123marrams
oghams1245853_oghams
orphans1237773orphans
praam94815613pra_am_
prahus11458243prah_us
prams96125513pr__ams
rabats83116223_rabats
radars71314673_radars
ragas65326063_raga_s
raias54631123_raia_s
rajahs16497663_rajahs
rajas127317723_raja_s
rams65950773_r__ams
ratals64219583_ratals
ratans63819373_ratans
rayahs12579193_rayahs
rayas85922053_raya_s
reams75729623_r_eams
rehabs1139023_rehabs
rehems113410983_rehems
roams74919613_r_oams
shams105829413__shams
sradhas1176153sradha_s
trams75327673tr__ams
trangams1147203trangams
trapans92812463trapans
traumas938593traumas
whams135515643__whams

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.390458182.1
2DLD Change Limit1340271515.79623124.1
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.23228673.1
 
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.