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

207 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
graham123785(None) 
grahams1335331grahams
brahma1336192brahma
graal64316502gra_al
gram77034582gr__am
grama85620282grama_
gramas94317202gramas
gramma11499802gramma
grana65722092grana_
grandam1139392grandam
granum9310912granum
praam94815612pra_am
agrapha1345133agrapha_
aha611246643__aha_
ahem97225363__ahem
arhat8327093ar_hat
brahmas1436733brahmas
brava106414793brava_
bravas114913323bravas
braza165214253braza_
brazas175812433brazas
bream95121813br_eam
brecham1646833brecham
cham115532313__cham
craal74117753cra_al
cram85635493cr__am
cravat11314443cravat
cream95721353cr_eam
dirham12378273dirham
drachm1436493drachm
drachma1544303drachma
dram75832003dr__am
drama85117423drama_
dramas95814663dramas
dream85120393dr_eam
fracas11311993fracas
fulham1435303fulham
gaga66625553g_aga_
gala55635163g_ala_
galah95917643g_alah
galas65731643g_alas
galax135314463g_alax
gam67060063g___am
gama77035523g_ama_
gamas85431363g_amas
gamay116419113g_amay
gamma106116103g_amma
garda7316763garda_
gardai839663gardai
gaum75726423g_a_um
gayal9312713g_ayal
gazar154612983g_azar
gerah9315303gerah__
gerahs1039413gerah_s
ghat86435283g__hat
gingham1484463gingham
glam76529343g__lam
gleam86916733g_leam
gloam86015943g_loam
gnathal1144353gnathal
goddam1145163goddam
graals74112913graals
grab75427613gr__ab
grabby14336183grabby
graben9419723graben
grabs85719693gra_bs
grace85124543gra_ce
graced105217903graced
graces94523493graces
grad66829863gr__ad
gradate9511233gradate
grade75126093gra_de
graded94919553graded
grader84919693grader
grades84926313grades
gradin83517483gradin
grads75625753gra_ds
gradual936943gradual
gradus84411223gradus
graft95327203gra_ft
grafts105013253grafts
grail64622873gra_il
grails77518783grails
grain65126253gra_in
grains74223093grains
grainy103914213grainy
gramary1355913gramary
grammar12406893grammar
grammas12499773grammas
gramme114210333gramme
gramp106218323gra_mp
grampa115010173grampa
grampas12399253grampas
gramps114114273gramps
grams85327313gra_ms
gran56335013gr__an
granary1157793granary
grand75122693gra_nd
grandad1038453grandad
grandame1247113grandame
grandams1237123grandams
granddam1344693granddam
grandma1136913grandma
grands84218243grands
grange83716203grange
granny104311163granny
grans64832543gra_ns
grant64840023gra_nt
grants73722473grants
grape84824663gra_pe
grapes95123123grapes
grapey126012303grapey
graph115315613gra_ph
graphed1498473graphed
grapheme1644013grapheme
graphic1537353graphic
graphs124510153graphs
grappa11396443grappa
grappas12357103grappas
grapy115416433gra_py
grasp84814483gra_sp
grasps9489253grasps
grass66125203gra_ss
grassy10619093grassy
grat55651283gr__at
grate64932883gra_te
grated84523923grated
grater74625443grater
grates75429893grates
gratin74520583gratin
gratis74819243gratis
gravamen1443933gravamen
grave94624873gra_ve
graved114818813graved
gravel105313823gravel
graven104513523graven
graver105018593graver
graves104624003graves
gravid113710983gravid
gravlax1842643gravlax
gravy125512113gra_vy
gray85329893gr__ay
grayed115415643grayed
grayer106014543grayer
graylag1283113graylag
grayly13287963grayly
grays95621333gra_ys
graze155820053gra_ze
grazed174115913grazed
grazer164815763grazer
grazes164519643grazes
great66034243gr_eat
grim76929423gr__im
groan65618423gr_oan
groat65531973gr_oat
grogram1147073grogram
groom85317983gr_oom
grum75625083gr__um
guaiac946153guaiac
guanay1037913guanay
guava938583guava_
guavas1037163guavas
haha107821063_haha_
hahas117118443_hahas
ham86363283___ham
kalam11315113_kalam
kraal94511823kra_al
lahar83114263_lahar
madam10316223_madam
marram10313883marram
ogham1138253_ogham
orphan1137733orphan
praams10459643pra_ams
prahu105013973prah_u
prahus11458243prahus
pram85733493pr__am
rabat72832223_rabat
radar61316723_radar
raga55930813_raga_
ragas65326063_ragas
rah68052403_rah__
raia46638383_raia_
raias54631123_raias
raja117918683_raja_
rajah155711423_rajah
rajas127317723_rajas
ram56867273_r__am
ramal74622243_ramal
raphae114311733_raphae
ratal55025113_ratal
ratan53722663_ratan
raya75224823_raya_
rayah116013503_rayah
rayas85922053_rayas
ream65841613_r_eam
rehab10312443_rehab
rehem103815353_rehem
roam67132413_r_oam
sham96436363__sham
shazam2046623shazam
sradha1085333sradha_
sradhas1176153sradhas
tram67034553tr__am
trangam1039363trangam
trapan82412973trapan
trauma838803trauma
wham125321693__wham

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162075.26621404.5
3Display Results2072070.0633285.7
 (SQL Overall)1786912075.73531158.0
 
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.