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

230 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
knawel1341541(None) 
knawe12397881knawe_
knawels14344681knawels
knawes13328391knawes
enamel81210112enamel
gnawed11427832gnawed
gnawer10386952gnawer
knave12389462knave_
knaves13439522knaves
kneel95012032kn_eel
knower1337082knower
navel87016572_navel
newel86114132_newel
snawed104813732snawed
unawed103914902unawed
anadem939183anadem
anal48037523ana__l
angel65019563an_gel
answer936893answer
awe67746623__awe_
awed88436033__awed
awee76336643__awee
awes76037553__awes
awl67635303__aw_l
awol75620673__awol
axel115222073__axel
babel95821693_babel
bagel85116793_bagel
bawl95326063_baw_l
blawed124713893blawed
boatel84314093boatel
bowel105621203_bowel
brawer114216333brawer
brawl106217963braw_l
camel96822803_camel
cancel105316683cancel
cannel84216403cannel
cawed116627063_cawed
chapel134911373chapel
chawed155214603chawed
chawer144314413chawer
clawed125115073clawed
clawer114512783clawer
crawl104916713craw_l
crewel114310483crewel
dawed106222813_dawed
dawen95413723_dawen
dowel95618193_dowel
drawee104413823drawee
drawer104711363drawer
drawl95516013draw_l
easel54521113_easel
enable83318483enable
enamels9128163enamels
enate54428153enate_
enates64026433enates
flawed134712723flawed
gavel95815183_gavel
gnarl65115573gna_rl
gnaw86515743gnaw__
gnawers11356393gnawers
gnawn9517783gnaw_n
gnaws96311143gnaw_s
gravel105313823gravel
hansel95214373hansel
hawed126025423_hawed
hazel176414813_hazel
inane52820343inane_
inanely1037943inanely
inaner62213543inaner
inanes62519803inanes
indwell1143903indwell
indwelt1146513indwelt
inkwell1442533inkwell
inwall938343inwall
jawed165517373_jawed
jewel156711703_jewel
kae76744543k_a_e_
kaes85734063k_a_es
kail85131493k_a_il
kale86533753k_ale_
kales95730983k_ales
kame105728233k_ame_
kames115024693k_ames
kane85133973k_ane_
kanes95529373k_anes
kantele1138253kantele
keel85729473k__eel
kennel10369223kennel
kernel104010593kernel
kevel124213103k_evel
khazen2233773khazen
kinase104210653kinase_
kinases113511123kinases
kittel10368873kittel
knack104311043kna_ck
knacked13287793knacked
knacker12307913knacker
knacks11428543knacks
knap105815403kna__p
knapped16397103knapped
knapper15387153knapper
knaps115511173kna_ps
knapweed1842443knapweed
knar85818723kna__r
knarred12266003knarred
knarry1334613knarry
knars94416113kna_rs
knaur9508253kna_ur
knaurs10466963knaurs
knavery1733123knavery
kneaded13146473kneaded
kneader1275893kneader
knee85323603kn__ee
kneed104612053kn_eed
kneels10408933kn_eels
knees95114873kn_ees
knell94210923kn_ell
knelt94617683kn__elt
knew115912123kn__ew
knife1210010133knife_
knifed14528123knifed
knifer13598563knifer
knifes136210213knifes
knives13458553knives
knoll9389603kn_oll
know116115843know__
knowers1436353knowers
known12568343know_n
knowns13426443knowns
knows124912413know_s
knurl9398913kn_url
koel84519943k__oel
kraal94511823kra_al
kraken955883kraken
krater104014313krater
krewe1238193krewe_
krewes1337923krewes
kugel1068573k_ugel
kummel14266173kummel
kvases13467103kvases
label75019383_label
lapel73716683_lapel
lawed96028323_lawed
mangel94017533mangel
mantel84317973mantel
mawed115824743_mawed
nabe66029493_nabe_
nabes75427093_nabes
nae35952743_na_e_
nail45838653_na_il
naked105320853_naked
naled65525053_naled
name65637413_name_
named85223063_named
namely113711323_namely
namer75622103_namer
names74833363_names
nape65230803_nape_
napes74828463_napes
nares55544153_nares
narwal938943_narwal
nasal56217593_nasal
natal53921493_natal
nates55238333_nates
naval85315833_naval
nave75732313_nave_
navels95712693_navels
naves87030383_naves
naw66346493_naw__
nawab10810923_nawab
newels93710823_newels
newer85717463_newer
ngwee9311073_ngwee
noel45226553_n_oel
novel85615993_novel
onager739663onager
panel76023623_panel
pawed115725613_pawed
pawer104422973_pawer
pawl95123263_paw_l
ratel54224883_ratel
ravel84621513_ravel
rawer84623733_rawer
rowel84721413_rowel
sawed95628403_sawed
sawer85026213_sawer
shawed134817233shawed
shawl116217573shaw_l
snail57020203sna_il
snake94821113snake_
snaked115017593snaked
snakes103919603snakes
snakey135011273snakey
snare54429983snare_
snared74824553snared
snarer64620843snarer
snares65329033snares
snarl54921083sna_rl
snaw78923073snaw__
snaws86116363snaw_s
snivel9368853snivel
snowed104613623snowed
tael46030713_ta_el
tawed95926193_tawed
tawer85223443_tawer
teasel63914983teasel
teazel15368543teazel
thawed13458463thawed
thawer12489343thawer
towel84920523_towel
tramel84113713tramel
travel94112983travel
trawl84915873traw_l
trowel94211463trowel
unable83819223unable
unaged83916423unaged
unaxed144113093unaxed
unravel1038063unravel
unreel63612933unreel
unsawed112911503unsawed
unwed94114873un_wed
unwell9349443un_well
unwet84423173un_wet
vowel115515013_vowel
wawl105321943_waw_l
weasel93410523weasel
yawed126022453_yawed
yawey14458273_yawey
yawl104918973_yaw_l

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.373479064.3
2DLD Change Limit1127162304.58024610.5
3Display Results2302300.0603833.3
 (SQL Overall)1786912305.01335645.5
 
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.