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

330 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
knarred1226600(None) 
gnarred9327011gnarred
barred95725792_barred
charred134614482charred
garred85217412_garred
gnarled9287722gnarled
inarmed10268672inarmed
jarred144613252_jarred
knacked13287792knacked
knapped16397102knapped
knarry1334612knarr_y
knurled1244652knurled
marred95421042_marred
nacred95212502_nacred
narked114116742_narked
parred95024072_parred
scarred104512632scarred
snared74824552sna_red
snarfed11378752snarfed
snarled83612362snarled
sparred104512862sparred
starred85013452starred
tarred74720282_tarred
unaired82916012unaired
unarmed101811922unarmed
unbarred11238702unbarred
unmarred11258402unmarred
warred104019842_warred
acred87126353__acred
aired66032923__aired
alarmed1037743alarmed
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
encored10412113encored
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
garbed104815663_garbed
garret74426563_garret
geared85317743gea_red
glaired9387753glaired
glared84715203gla_red
gnarr64810693gnarr__
gnarrs7407663gnarr_s
gnashed12317523gnashed
gnawed11427833gna_wed
guarded1036153guarded
haired105117173_haired
hared95742183_ha_red
harked145422553_harked
harmed125218833_harmed
harped124418403_harped
harried113815533_harried
hatred104814333_hatred
hearsed113811413hearsed
hearted113314023hearted
hoarded12368343hoarded
inarched1486113inarched
inbred93010403in_bred
inbreed10267643inbreed
incurred1136493incurred
inferred12248353inferred
infrared1236193infrared
inhered11313163inhered
injured15339063injured
instarred1043963instarred
insured83714253insured
interred92615263interred
inured73114813in_ured
inurned8328053inurned
karroo10410013k_arroo
kayoed14416903k_ayoed
kerbed13339703k_erbed
kerfed14358233k_erfed
kerned114112933k_erned
kindred13316953kindred
kirned11408623k_irned
knacker12307913knacker
knackered1543683knackered
knapper15387153knapper
knapweed1842443knapweed
knar85818723kna_r__
knars94416113kna_r_s
knaur9508253knaur__
knaurs10466963knaur_s
knave12389463kna_ve_
knavery1733123knavery
knaves13439523kna_ves
knawe12397883kna_we_
knawel13415413kna_wel
knawes13328393kna_wes
kneaded13146473kneaded
kneed104612053kn__eed
kneeled12328073kneeled
knelled12338993knelled
knifed14528123kn_ifed
knitted12337423knitted
knobbed1633713knobbed
knocked13236303knocked
knolled12296573knolled
knopped16355453knopped
knotted12357233knotted
knouted12416773knouted
kraaled12254983kraaled
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
narrowed1235213_narrowed
natured838963_natured
neared75119813_neared
nerved104111693_nerved
normed95014543_normed
nurled74016233_nurled
nursed74514673_nursed
oared65030653_oa_red
paired95017523_paired
pared86946763_pa_red
parged104922043_parged
parked134425143_parked
parled94626293_parled
parrel84515983_parrel
parried103615723_parried
parsed96323893_parsed
parted94228683_parted
pearled10411553pearled
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
wearied112911813wearied
wharfed1734413wharfed
whirred14386933whirred
yarded114714023_yarded
yarned105514023_yarned
yearned11327373yearned
yirred10426963_yirred

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 Limit1340273305.68623571.4
3Display Results3303300.1402357.1
 (SQL Overall)1786913306.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.