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

398 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
gnarred932700(None) 
garred85217401g_arred
gnarled9287721gnarled
knarred12266001knarred
barred95725792_barred
charred134614482charred
garbed104815662g_arbed
garret74426552g_arret
geared85317742gea_red
glaired9387742glaired
glared84715192gla_red
gnarr64810692gnarr__
gnarrs7407662gnarr_s
gnashed12317522gnashed
gnawed11427832gna_wed
guarded1036152guarded
inarmed10268672inarmed
jarred144613252_jarred
marred95421042_marred
nacred95212492_nacred
narked114116742_narked
parred95024072_parred
scarred104512632scarred
snared74824552sna_red
snarfed11378752snarfed
snarled83612362snarled
sparred104512862sparred
starred85013452starred
tarred74720282_tarred
unaired82916012unaired
unarmed101811922unarmed
unbarred11238702unbarred
unmarred11258402unmarred
warred104019842_warred
acred87126353__acred
aired66032923__aired
alarmed1037733alarmed
aneared8512743aneared
angered93013473angered
antired82316193antired
arced88224163__arced
armed86324433__armed
averred11237593averred
awarded1236223awarded
barbed115121313_barbed
barded105426423_barded
bared85144483_ba_red
barfed125416383_barfed
barged105822643_barged
barked135027313_barked
barned95623583_barned
barre75929543_barre_
barrel84517873_barrel
barren85317613_barren
barres84427543_barres
barret84930483_barret
bearded114212133bearded
birred94713203_birred
blared95018243bla_red
blurred10427803blurred
boarded113910503boarded
burred95820723_burred
carded105424903_carded
cared86050093_ca_red
caried94528693_caried
carked134024823_carked
carped115923763_carped
carrel84718633_carrel
carried103717153_carried
carted98631443_carted
carved124320853_carved
chaired134211243chaired
chared125423693cha_red
charged144614023charged
charked174814013charked
charmed154714253charmed
charted135116853charted
chirred133612123chirred
churred13409173churred
curred94319263_curred
dared75935013_da_red
darked123919633_darked
darned85018483_darned
darted84620923_darted
deaired9411533deaired
debarred12165633debarred
dwarfed1533483dwarfed
eared65139503_ea_red
earned74818333_earned
embarred13174793embarred
enabled102510633enabled
enacted10310643enacted
enamored1147033enamored
encored10412103encored
endured93611213endured
enlarged1035413enlarged
enraged93511783enraged
ensured83512943ensured
entered82718883entered
enured73315333en_ured
erred65915673__erred
faired105915773_faired
farced125216533_farced
farded114518953_farded
fared95842343_fa_red
farmed125117653_farmed
farted105121783_farted
feared106320433fea_red
flared105317603fla_red
furred104514433_furred
gabbed125216893g_abbed
gabled105518453g_abled
gadded103913173g_added
gaed66031513g_a__ed
gaffed144210203g_affed
gaged85522313g_a_ged
gagged104817153g_agged
gained84617463g_ained
gaited84416923g_aited
galled84622863g_alled
gamed95126393g_a_med
gammed124216163g_ammed
gandered112211173gandered
ganged94619193g_anged
gangrel996143gangrel
gaoled84814503g_aoled
gaped96123533g_a_ped
gapped124217123g_apped
garaged1039253g_araged
garbled114512803g_arbled
garden84215083g_arden
garget84327273g_arget
gargled104210673g_argled
garner73917003g_arner
garnered10247113g_arnered
garnet73928413g_arnet
garoted9710133g_aroted
garreted1057523g_arreted
garrets84413623g_arrets
garron73113493g_arron
garroted1056783g_arroted
garter74420513g_arter
gartered10319583g_artered
garvey13127873g_arvey
gashed116321973g_ashed
gasped104814293g_asped
gassed85217633g_assed
gasted84821583g_asted
gated75329773g_a_ted
gauged94713473g_auged
gaumed104610323g_aumed
gawked15468763g_awked
gawped13509073g_awped
gazed165520333g_a_zed
gearhead1344433gearhead
gendered11258873gendered
gharri10386163gharr_i
gharries12318203gharries
gharris11306433gharris
gharry13546273gharr_y
gingered11127743gingered
girded93712493g_irded
girned84010513g_irned
girted83912873g_irted
glaceed1136193glaceed
gladded11357453gladded
glaire74411293glaire_
glaires84010133glaires
glaived12375973glaived
glanced11439233glanced
glare65222953gla_re_
glares75518863gla_res
glarier84112203glarier
glassed93710433glassed
glazed174711773gla_zed
gloried9169513gloried
gnar56021383gna_r__
gnarl65115573gna_r_l
gnarlier9255163gnarlier
gnarls74210773gna_rls
gnarly104610383gna_rly
gnarring10225973gnarring
gnars66718853gna_r_s
gnashes11419573gnashes
gnawer10386953gna_wer
gnawers11356393gnawers
goaded94913713goa_ded
goaled85014363goa_led
goateed9307063goateed
gored75227083g__ored
gorged95016983g_orged
gormed105013833g_ormed
grabbed13368643grabbed
graced105217903gra_ced
graded94919553gra_ded
grafted124110223grafted
grained93814273grained
granted94715103granted
graphed1498473graphed
grasped11409063grasped
grassed93812793grassed
grated84523923gra_ted
graved114818813gra_ved
grayed115415643gra_yed
grazed174115913gra_zed
greed75125693g__reed
guard74415543gua_r_d
guarder936463guarder
gurged95513363g_urged
gyrated12428413gyrated
gyred105114093g__yred
haired105117173_haired
hared95742183_ha_red
harked145422553_harked
harmed125218833_harmed
harped124418403_harped
harried113815533_harried
hatred104814333_hatred
hearsed113811403hearsed
hearted113314023hearted
hoarded12368343hoarded
ignored9226443ign_ored
inarched1486113inarched
inbred93010403in_bred
inbreed10267643inbreed
incurred1136493incurred
inferred12248353inferred
infrared1236193infrared
inhered11313163inhered
injured15339063injured
instarred1043963instarred
insured83714253insured
interred92615263interred
inured73114813in_ured
inurned8328053inurned
knacked13287793knacked
knapped16397103knapped
knarry1334613knarr_y
knurled1244643knurled
laired75216813_laired
larded84319093_larded
larked114519473_larked
learned8329303learned
manured1039473manured
marked133921623_marked
marled95523163_marled
marrer83716673_marrer
married104715303_married
marted94425213_marted
nabbed115113613_nabbed
nacre75715363_nacre_
nacres85614453_nacres
naffed13408333_naffed
nagged93916053_nagged
nailed74021493_nailed
naked105320853_na_ked
naled65525053_na_led
named85223063_na_med
napped114218163_napped
nard56634453_na_r_d
nares55544153_na_res
narrated9310323_narrated
narrow9269143_narrow
narrowed1235203_narrowed
natured838963_natured
neared75119803_neared
nerved104111683_nerved
normed95014543_normed
nurled74016233_nurled
nursed74514663_nursed
oared65030653_oa_red
paired95017523_paired
pared86946763_pa_red
parged104922043_parged
parked134425143_parked
parled94626283_parled
parrel84515983_parrel
parried103615723_parried
parsed96323893_parsed
parted94228683_parted
pearled10411543pearled
purred94218073_purred
quarrel1636103quarrel
quarried1836093quarried
rared65738323_ra_red
reared75930013rea_red
rearmed103912823rearmed
roared75015393roa_red
sabred95916533_sabred
sacred94917103_sacred
scared95227293sca_red
scarfed134711183scarfed
scarped124314403scarped
scarted104816123scarted
seared75232843sea_red
shared105829063sha_red
sharked153613913sharked
sharped134112053sharped
shirred113710503shirred
skirred12347083skirred
slurred8359193slurred
smarted105012613smarted
snacked144013113snacked
snafued1134933snafued
snagged104010673snagged
snailed83811923snailed
snaked115017593sna_ked
snapped124611203snapped
snare54429983sna_re_
snarer64620843sna_rer
snarers74216663snarers
snares65329033sna_res
snarler73610633snarler
snawed104813733sna_wed
sneered83113973sneered
snored74819543sn_ored
snorted83813493snorted
soared74324293soa_red
spared95427493spa_red
sparged113512763sparged
sparked143513143sparked
spurred103610623spurred
stared75429873sta_red
started84217323started
starved114911573starved
stirred8359703stirred
swarded1238153swarded
swarmed1367483swarmed
tared69340053_ta_red
tarre55825633_tarre_
tarres64723043_tarres
tarried83914133_tarried
tarted74923373_tarted
teared75722153tea_red
tiaraed837053tiaraed
unacted10312733unacted
unadded10238523unadded
unaged83916423una_ged
unagreed1036823unagreed
unaided92414603unaided
unaimed102812493unaimed
unarched14128553unarched
unargued1035583unargued
unarmored1244873unarmored
unarrayed1344183unarrayed
unasked122010023unasked
unawed103914903una_wed
unaxed144113093una_xed
unbarbed13217753unbarbed
unbred92613303un_bred
uncarded12310133uncarded
uncarted11312053uncarted
uncarved1438163uncarved
uncharred1536103uncharred
uncured10513233uncured
undried92314613undried
unearned9310063unearned
unfired112212453unfired
unfreed11510123unfreed
ungarbed12197063ungarbed
unhaired12238763unhaired
unharmed1438093unharmed
unharried1344763unharried
unhired112512153unhired
unmarked15248813unmarked
unmarried1244583unmarried
unpaired11208943unpaired
unparted11310823unparted
unraked122914013unraked
unrated82621553unrated
unrazed172511453unrazed
unscarred1235673unscarred
unstarred1036363unstarred
untired82316383untired
untried82615853untried
unurged939143unurged
unvaried1239683unvaried
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
varied104817863_varied
varved134110603_varved
waired106015833_waired
warded115021043_warded
wared96339873_wa_red
warked144421213_warked
warmed124516893_warmed
warned104018913_warned
warped124816413_warped
warren95012853_warren
warted104223233_warted
wearied112911803wearied
wharfed1734413wharfed
whirred14386933whirred
yarded114714023_yarded
yarned105514023_yarned
yearned11327373yearned
yirred10426963_yirred

Search took 19 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.1561145455.1
2DLD Change Limit13402739817.8737498.9
3Display Results3983980.1402842.9
 (SQL Overall)17869139818.1699834.9
 
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.